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); }
public static void UpdateRepCS(RaiseSalesCsUI obj) { string cs = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; //var loggedInUserId = Convert.ToInt32(HttpContext.Current.Session["LoggedUserID"].ToString()); var change = "Status Not changed"; var preval = ""; if (obj.Status == false) { preval = "Not Completed"; } if (obj.Status) { change = "Completed"; } CreateAuditRecord(obj.Id, change, preval, obj); new RaiseCsSalesRepDAL(cs).UpdateSalesRepCsById(obj); }
private static void CreateAuditRecord(int rsId, string changed, string preValus, RaiseSalesCsUI newObj) { var columnName = "All Column"; var talbeName = "RaiseCS"; var ActionType = "Changed"; 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 change = "Status Not changed"; if (newObj.Status == false) { change = "Not Completed"; } if (newObj.Status) { change = "Completed"; } var newvalues = "Customer Service Id " + rsId + " Customer Service Updated. Status " + changed + " . Issue " + newObj.Complaint + ". OutCome " + newObj.OutCome + " . Question " + newObj.Question; preValus = "Customer Service Id " + rsId + "Status " + change + " . Issue " + obj.Complaint + ". OutCome " + obj.OutCome + " . Question " + obj.Question; SqlConnection conn = new SqlConnection(); conn.ConnectionString = CONNSTRING; var previousValues = preValus; 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)); }