Create XML Code and call Stored Procedure & bind data into model

XML Code and Call Stored Procedure (Bind into model)

C# Code
=============================================================================================================================
Here we create an xml code and we parse or get data from xml file using SQL (Stored Procedure)
------------------------------------------------------------------------------------------------

public string AddEntitlementMaster(EntitlementMaster EmModel)
        {
            String strXmlString;
            string empId = EmModel.vEmpId;

            strXmlString = "<ENTITLEMENTDETAIL_MST>" + " ";
            strXmlString = strXmlString + "<EMP_ROW>" + " ";
            strXmlString = strXmlString + "<vEmpId>" + EmModel.vEmpId + "</vEmpId>" + " ";

            //if (String.IsNullOrEmpty(EmModel.EmployeeName.Trim()))
            //{
            //    strXmlString = strXmlString + "<EmployeeName></EmployeeName>" + " ";
            //}
            //else
            //    strXmlString = strXmlString + "<EmpName>" + EmModel.EmployeeName + "</EmpName>" + " ";

            strXmlString = strXmlString + "<vHotel>" + EmModel.Hotel + "</vHotel>" + " ";
            strXmlString = strXmlString + "<vHotDA>" + EmModel.Fixed_Hotel_DA + "</vHotDA>" + " ";
            strXmlString = strXmlString + "<nCommunication>" + EmModel.Communication + "</nCommunication>" + " ";
            strXmlString = strXmlString + "<nAdvance>" + EmModel.Advance + "</nAdvance>" + " ";
            strXmlString = strXmlString + "<vDA>" + EmModel.DA + "</vDA>" + " ";
            strXmlString = strXmlString + "<nImprest>" + EmModel.Imprest + "</nImprest>" + " ";
            strXmlString = strXmlString + "<nInternet>" + EmModel.Internet + "</nInternet>" + " ";
            strXmlString = strXmlString + "<nConveyance>" + EmModel.Conveyance + "</nConveyance>" + " ";
            strXmlString = strXmlString + "<nProject>" + EmModel.Project + "</nProject>" + " ";
            strXmlString = strXmlString + "<vRemark>" + EmModel.Remark + "</vRemark>" + " ";
            strXmlString = strXmlString + "</EMP_ROW>" + " ";
            strXmlString = strXmlString + "</ENTITLEMENTDETAIL_MST>" + " ";
            strXmlString = strXmlString.Replace("&", "&amp;");

            return Convert.ToString(SqlHelper.ExecuteScalar(cnSetting.cnString, "EHD_EM_MASTER_INSERT", new object[] { empId, strXmlString }));
        }
	
=============================================================================================================================
Here we get data (record) from SQL table using Stored Procedure.
------------------------------------------------------------------------------------------------

public List<EntitlementMaster> GetEntitlementMasterList(int SlNo)
        {
            string query = ""; string flag = "A";
            string empId = Convert.ToString(SlNo);

            #region SQL Objects.
            SqlConnection sqlCon = new SqlConnection(conString);
            sqlCon.Open();
            SqlCommand cmd = new SqlCommand();

            cmd = new SqlCommand("EHD_EM_MASTER_LIST", sqlCon);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlDataReader sqlReader = null;
            DataTable table = new DataTable();
            int numRows = 0;
            #endregion

            List<EntitlementMaster> EntMaster_list = new List<EntitlementMaster>();

            if (SlNo != 0)
            {
                //string empId = Convert.ToString(SlNo);
                //query = "select * from ENTITLEMENTDETAIL_MST where vEmpId='" + empId + "' order by vEmpId ";
                try
                {
                    flag = "S";
                    cmd.Parameters.Add(new SqlParameter("@empId", SqlDbType.VarChar)).Value = empId;
                    cmd.Parameters.Add(new SqlParameter("@flag", SqlDbType.VarChar)).Value = flag;
                    sqlReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

                    table.Load(sqlReader);
                    numRows = table.Rows.Count;
                }
                catch (Exception ex)
                {
                    string errormsg = ex.Message;
                }
            }
            else
            {
                try
                {
                    cmd.Parameters.Add(new SqlParameter("@empId", SqlDbType.VarChar)).Value = empId;
                    cmd.Parameters.Add(new SqlParameter("@flag", SqlDbType.VarChar)).Value = flag;
                    sqlReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

                    table.Load(sqlReader);
                    numRows = table.Rows.Count;
                }
                catch (Exception ex)
                {
                    string errormsg = ex.Message;
                }
            }

            for (int index = 0; index < numRows; index++)
            {
                EntitlementMaster EntMaster = new EntitlementMaster();

                EntMaster.vEmpId = table.Rows[index]["vEmpId"].ToString();
                EntMaster.Hotel = table.Rows[index]["vHotel"].ToString();
                EntMaster.Fixed_Hotel_DA = table.Rows[index]["vHotDA"].ToString();
                EntMaster.DA = table.Rows[index]["vDA"].ToString();
                EntMaster.Communication = table.Rows[index]["nCommunication"].ToString();
                EntMaster.Advance = table.Rows[index]["nAdvance"].ToString();
                EntMaster.Remark = table.Rows[index]["vRemark"].ToString();
                EntMaster.Imprest = table.Rows[index]["nImprest"].ToString();
                EntMaster.Internet = table.Rows[index]["nInternet"].ToString();
                EntMaster.Project = table.Rows[index]["nProject"].ToString();
                EntMaster.Conveyance = table.Rows[index]["nConveyance"].ToString();

                EntMaster_list.Add(EntMaster);
            }

            return EntMaster_list;
        }
		
=========================================================================================================================
Here we delete record using SP - (Below Code)
-------------------------------------------------------


        public void Delete(string empId)
        {
            //clsDataServer.ExecuteNonQuery("DELETE FROM EHD_Entitlement_Master WHERE Id=" + empId);

            Convert.ToString(SqlHelper.ExecuteScalar(cnSetting.cnString, "EHD_EM_MASTER_DELETE", new object[] { empId }));
        }

==============================================================================================================================
Here we get current system IPv4 Address (IP Address)
-----------------------------------------------------------------------------------------------

public string GetCurrentSystemIPAddress()
        {
            string ipAddress = "";

            using (Socket socket = new Socket(AddressFamily.InterNetwork, SocketType.Dgram, 0))
            {
                socket.Connect("8.8.8.8", 65530);
                IPEndPoint endPoint = socket.LocalEndPoint as IPEndPoint;
                ipAddress = endPoint.Address.ToString();
            }

            //if (Dns.GetHostAddresses(Dns.GetHostName()).Length > 0)
            //{
            //    ipAddress = Dns.GetHostAddresses(Dns.GetHostName())[0].ToString();
            //}

            return ipAddress;
        }