private static void DeleteAuditRecord(int rsId)
        {
            var columnName     = "All Column";
            var talbeName      = "RaiseCS";
            var ActionType     = "DELETED";
            int primaryKey     = rsId;
            var loggedInUserId = Convert.ToInt32(HttpContext.Current.Session["LoggedUserID"].ToString());

            var CONNSTRING = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;

            var obj = new RaiseCsSalesRepDAL(CONNSTRING).ReadSalesRepCsById(rsId);


            var newvalues = "Customer Service  Id " + rsId + " Customer Service Deleted .Issue "
                            + obj.Complaint + ". OutCome " + obj.OutCome + " . Question" + obj.Question;



            SqlConnection conn = new SqlConnection();

            conn.ConnectionString = CONNSTRING;
            var previousValues = "";
            var strCompanyID   = new RaiseCsSalesRepDAL(CONNSTRING).GetCompanyIDByRaisedId(rsId);

            new DeltoneCRM_DAL.CompanyDAL(CONNSTRING).CreateActionONAuditLog(previousValues, newvalues, loggedInUserId, conn, 0,
                                                                             columnName, talbeName, ActionType, primaryKey, Convert.ToInt32(strCompanyID));
        }
        public static RaiseSalesCsUI ReadSalesRepCS(int csId)
        {
            string cs  = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
            var    obj = new RaiseSalesCsUI();

            obj.Id = csId;
            if (csId > 0)
            {
                var loggedInUserId = Convert.ToInt32(HttpContext.Current.Session["LoggedUserID"].ToString());

                obj = new RaiseCsSalesRepDAL(cs).ReadSalesRepCsById(csId);
            }

            return(obj);
        }