public BOTS_TblSMSConfig GetCommunicationSMSConfig(string GroupId, string BrandId)
{
BOTS_TblSMSConfig objData = new BOTS_TblSMSConfig();
using (var context = new CommonDBContext())
{
if (BrandId != "0")
{
objData = context.BOTS_TblSMSConfig.Where(x => x.GroupId == GroupId && x.BrandId == BrandId).FirstOrDefault();
}
else
{
objData = context.BOTS_TblSMSConfig.Where(x => x.GroupId == GroupId && x.BrandId == "All").FirstOrDefault();
}
}
return(objData);
}
public bool SaveCommunicationConfig(BOTS_TblSMSConfig objSMSData, BOTS_TblWAConfig objWAData)
{
bool status = false;
using (var context = new CommonDBContext())
{
using (DbContextTransaction transaction = context.Database.BeginTransaction())
{
try
{
if (objSMSData.IsSMS)
{
if (objSMSData.BrandId == "All")
{
var allBrandData = context.BOTS_TblSMSConfig.Where(x => x.BrandId != "All").ToList();
foreach (var item in allBrandData)
{
context.BOTS_TblSMSConfig.Remove(item);
context.SaveChanges();
}
}
else
{
var allBrandData = context.BOTS_TblSMSConfig.Where(x => x.BrandId == "All").ToList();
foreach (var item in allBrandData)
{
context.BOTS_TblSMSConfig.Remove(item);
context.SaveChanges();
}
}
if (objSMSData.Id > 0)
{
var oldData = context.BOTS_TblSMSConfig.Where(x => x.Id == objSMSData.Id).FirstOrDefault();
if (oldData != null)
{
objSMSData.AddedBy = oldData.AddedBy;
objSMSData.AddedDate = oldData.AddedDate;
}
}
context.BOTS_TblSMSConfig.AddOrUpdate(objSMSData);
context.SaveChanges();
status = true;
}
if (objWAData.IsWA)
{
if (objWAData.BrandId == "All")
{
var allBrandData = context.BOTS_TblWAConfig.Where(x => x.BrandId != "All").ToList();
foreach (var item in allBrandData)
{
context.BOTS_TblWAConfig.Remove(item);
context.SaveChanges();
}
}
else
{
var allBrandData = context.BOTS_TblWAConfig.Where(x => x.BrandId == "All").ToList();
foreach (var item in allBrandData)
{
context.BOTS_TblWAConfig.Remove(item);
context.SaveChanges();
}
}
if (objWAData.Id > 0)
{
var oldData = context.BOTS_TblWAConfig.Where(x => x.Id == objWAData.Id).FirstOrDefault();
if (oldData != null)
{
objWAData.AddedBy = oldData.AddedBy;
objWAData.AddedDate = oldData.AddedDate;
}
}
context.BOTS_TblWAConfig.AddOrUpdate(objWAData);
context.SaveChanges();
status = true;
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
newexception.AddException(ex, "SaveCommunicationConfig");
}
}
}
return(status);
}
public ActionResult SaveCommunicationConfig(string jsonData)
{
bool status = false;
try
{
var userDetails = (CustomerLoginDetail)Session["UserSession"];
BOTS_TblSMSConfig objSMSConfig = new BOTS_TblSMSConfig();
BOTS_TblWAConfig objWAConfig = new BOTS_TblWAConfig();
JavaScriptSerializer json_serializer = new JavaScriptSerializer();
json_serializer.MaxJsonLength = int.MaxValue;
object[] objCommConfigData = (object[])json_serializer.DeserializeObject(jsonData);
foreach (Dictionary <string, object> item in objCommConfigData)
{
var isSMS = Convert.ToBoolean(item["IsSMS"]);
if (isSMS)
{
objSMSConfig.IsSMS = true;
if (!string.IsNullOrEmpty(Convert.ToString(item["SMSId"])))
{
objSMSConfig.Id = Convert.ToInt32(item["SMSId"]);
}
objSMSConfig.SMSProvider = Convert.ToString(item["SMSProvider"]);
objSMSConfig.GroupId = Convert.ToString(item["GroupId"]);
objSMSConfig.BrandId = Convert.ToString(item["BrandId"]);
objSMSConfig.SMSSenderID = Convert.ToString(item["SMSSenderId"]);
objSMSConfig.SMSUsername = Convert.ToString(item["SMSUserName"]);
objSMSConfig.SMSPassword = Convert.ToString(item["SMSPassword"]);
objSMSConfig.SMSlink = Convert.ToString(item["SMSLink"]);
objSMSConfig.EnrolmentSMSScript = Convert.ToString(item["SMSEnrollment"]);
objSMSConfig.EnrollmentEarnSMSScript = Convert.ToString(item["SMSEnrollmentAndEarn"]);
objSMSConfig.EarnSMSScript = Convert.ToString(item["SMSEarn"]);
objSMSConfig.OTPSMSScript = Convert.ToString(item["SMSOTP"]);
objSMSConfig.BurnSMSScript = Convert.ToString(item["SMSBurn"]);
objSMSConfig.CancelEarnSMSScript = Convert.ToString(item["SMSCancelEarn"]);
objSMSConfig.CancelBurnSMSScript = Convert.ToString(item["SMSCancelBurn"]);
objSMSConfig.AnyCancelSMSScript = Convert.ToString(item["SMSAnyCancel"]);
objSMSConfig.BalanceInquirySMSScript = Convert.ToString(item["SMSBalanceInquiry"]);
if (objSMSConfig.Id > 0)
{
objSMSConfig.UpdatedBy = userDetails.LoginId;
objSMSConfig.UpdatedDate = DateTime.Now;
}
else
{
objSMSConfig.AddedBy = userDetails.LoginId;
objSMSConfig.AddedDate = DateTime.Now;
}
}
else
{
objSMSConfig.IsSMS = false;
}
var isWA = Convert.ToBoolean(item["IsWA"]);
if (isWA)
{
objWAConfig.IsWA = true;
if (!string.IsNullOrEmpty(Convert.ToString(item["WAId"])))
{
objWAConfig.Id = Convert.ToInt32(item["WAId"]);
}
objWAConfig.WAProvider = Convert.ToString(item["WAProvider"]);
objWAConfig.GroupId = Convert.ToString(item["GroupId"]);
objWAConfig.BrandId = Convert.ToString(item["BrandId"]);
objWAConfig.WANumber = Convert.ToString(item["WANumber"]);
objWAConfig.WAUsername = Convert.ToString(item["WAUserName"]);
objWAConfig.WAPassword = Convert.ToString(item["WAPassword"]);
objWAConfig.WAlink = Convert.ToString(item["WALink"]);
objWAConfig.EnrolmentWAScript = Convert.ToString(item["WAEnrollment"]);
objWAConfig.EnrollmentEarnWAScript = Convert.ToString(item["WAEnrollmentAndEarn"]);
objWAConfig.EarnWAScript = Convert.ToString(item["WAEarn"]);
objWAConfig.OTPWAScript = Convert.ToString(item["WAOTP"]);
objWAConfig.BurnWAScript = Convert.ToString(item["WABurn"]);
objWAConfig.CancelEarnWAScript = Convert.ToString(item["WACancelEarn"]);
objWAConfig.CancelBurnWAScript = Convert.ToString(item["WACancelBurn"]);
objWAConfig.AnyCancelWAScript = Convert.ToString(item["WAAnyCancel"]);
objWAConfig.BalanceInquiryWAScript = Convert.ToString(item["WABalanceInquiry"]);
if (objWAConfig.Id > 0)
{
objWAConfig.UpdatedBy = userDetails.LoginId;
objWAConfig.UpdatedDate = DateTime.Now;
}
else
{
objWAConfig.AddedBy = userDetails.LoginId;
objWAConfig.AddedDate = DateTime.Now;
}
}
else
{
objWAConfig.IsWA = false;
}
}
status = OBR.SaveCommunicationConfig(objSMSConfig, objWAConfig);
}
catch (Exception ex)
{
}
return(new JsonResult()
{
Data = status, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue
});
}
