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); }