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