public SPResponse ActiveInactiveCS(int RmAssignedId)
{
tblRMAssigned objRM = new tblRMAssigned();
SPResponse result = new SPResponse();
using (var context = new CommonDBContext())
{
objRM = context.tblRMAssigneds.Where(x => x.RMAssignedId == RmAssignedId).FirstOrDefault();
if (objRM.IsActive == true)
{
objRM.IsActive = false;
}
else
{
objRM.IsActive = true;
}
context.tblRMAssigneds.AddOrUpdate(objRM);
context.SaveChanges();
result.ResponseCode = "00";
result.ResponseMessage = "CS Updated Successfully";
}
return(result);
}
public ActionResult AddRM(string jsonData)
{
SPResponse result = new SPResponse();
var userDetails = (CustomerLoginDetail)Session["UserSession"];
string CSId = "";
try
{
JavaScriptSerializer json_serializer = new JavaScriptSerializer();
json_serializer.MaxJsonLength = int.MaxValue;
object[] objData = (object[])json_serializer.DeserializeObject(jsonData);
tblRMAssigned objRM = new tblRMAssigned();
foreach (Dictionary <string, object> item in objData)
{
objRM.RMAssignedName = Convert.ToString(item["CSNm"]);
objRM.CreatedBy = userDetails.LoginId;
objRM.CreatedDate = DateTime.Now;
CSId = Convert.ToString(item["CSId"]);
objRM.IsActive = Convert.ToBoolean(item["IsActive"]);
if (CSId != "")
{
objRM.RMAssignedId = Convert.ToInt32(CSId);
}
else
{
}
}
result = COR.AddRM(objRM);
}
catch (Exception ex)
{
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public tblRMAssigned GetRMById(int RMId)
{
tblRMAssigned objRM = new tblRMAssigned();
using (var context = new CommonDBContext())
{
objRM = context.tblRMAssigneds.Where(x => x.RMAssignedId == RMId).FirstOrDefault();
}
return(objRM);
}
public ActionResult GetRM(int RMId)
{
tblRMAssigned objRM = new tblRMAssigned();
try
{
objRM = COR.GetRMById(RMId);
}
catch (Exception ex)
{
}
return(Json(objRM, JsonRequestBehavior.AllowGet));
}
public SPResponse AddRM(tblRMAssigned objtblRMAssigned)
{
SPResponse result = new SPResponse();
try
{
using (var context = new CommonDBContext())
{
context.tblRMAssigneds.AddOrUpdate(objtblRMAssigned);
context.SaveChanges();
result.ResponseCode = "00";
result.ResponseMessage = "Customer Success Added Successfully";
}
}
catch (Exception ex)
{
newexception.AddException(ex, "onboarding_master");
}
return(result);
}
public int AddGroupDetails(tblGroupDetail objGroupDetails)
{
int GroupId = 0;
using (var context = new CommonDBContext())
{
using (DbContextTransaction transaction = context.Database.BeginTransaction())
{
try
{
if (!string.IsNullOrEmpty(objGroupDetails.OtherBillingPartner))
{
tblBillingPartner objBillingPartner = new tblBillingPartner();
objBillingPartner.BillingPartnerName = objGroupDetails.OtherBillingPartner;
context.tblBillingPartners.AddOrUpdate(objBillingPartner);
context.SaveChanges();
objGroupDetails.BillingPartner = objBillingPartner.BillingPartnerId;
}
if (!string.IsNullOrEmpty(objGroupDetails.OtherCity))
{
tblCity objCity = new tblCity();
objCity.CityName = objGroupDetails.OtherCity;
context.tblCities.AddOrUpdate(objCity);
context.SaveChanges();
objGroupDetails.City = objCity.CityId;
}
if (!string.IsNullOrEmpty(objGroupDetails.OtherRetailCategory))
{
tblCategory objCategory = new tblCategory();
objCategory.CategoryName = objGroupDetails.OtherRetailCategory;
context.tblCategories.AddOrUpdate(objCategory);
context.SaveChanges();
objGroupDetails.RetailCategory = objCategory.CategoryId;
}
if (!string.IsNullOrEmpty(objGroupDetails.OtherRMAssigned))
{
tblRMAssigned objRMAssigned = new tblRMAssigned();
objRMAssigned.RMAssignedName = objGroupDetails.OtherRMAssigned;
context.tblRMAssigneds.AddOrUpdate(objRMAssigned);
context.SaveChanges();
objGroupDetails.RMAssigned = objRMAssigned.RMAssignedId;
}
if (!string.IsNullOrEmpty(objGroupDetails.OtherSourcedBy))
{
tblSourcedBy objSourcedBy = new tblSourcedBy();
objSourcedBy.SourcedbyName = objGroupDetails.OtherSourcedBy;
context.tblSourcedBies.AddOrUpdate(objSourcedBy);
context.SaveChanges();
objGroupDetails.SourcedBy = objSourcedBy.SourcedbyId;
}
if (!string.IsNullOrEmpty(objGroupDetails.Logo))
{
//Upload Logo Image
var profilePhysicalURL = System.Configuration.ConfigurationManager.AppSettings["LogoPhysicalURL"];
string filePhysicalPath = System.IO.Path.Combine(profilePhysicalURL + "\\");
string base64String = Convert.ToString(objGroupDetails.LogoBase64);
byte[] newBytes = Convert.FromBase64String(base64String);
MemoryStream ms = new MemoryStream(newBytes, 0, newBytes.Length);
ms.Write(newBytes, 0, newBytes.Length);
var fileName = Convert.ToString(objGroupDetails.GroupId + ".jpg");
FileStream fileNew = new FileStream(filePhysicalPath + "\\" + fileName, FileMode.Create, FileAccess.Write);
ms.WriteTo(fileNew);
fileNew.Close();
ms.Close();
objGroupDetails.Logo = fileName;
}
string grpId = Convert.ToString(objGroupDetails.GroupId);
//Check Customer DB exist
var DBDetails = context.DatabaseDetails.Where(x => x.GroupId == grpId).FirstOrDefault();
if (DBDetails == null)
{
//Create Customer DB And Add Entry to DatabaseDetails Table
var LastGroupId = context.tblGroupDetails.OrderByDescending(x => x.GroupId).Take(1).Select(y => y.GroupId).FirstOrDefault();
objGroupDetails.GroupId = LastGroupId + 1;
}
context.tblGroupDetails.AddOrUpdate(objGroupDetails);
context.SaveChanges();
transaction.Commit();
GroupId = objGroupDetails.GroupId;
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
return(GroupId);
}
