public bool ModifyTransaction(string GroupId, long TransactionId, decimal points, tblAudit objAudit) { bool status = false; string connStr = objCustRepo.GetCustomerConnString(GroupId); using (var contextNew = new BOTSDBContext(connStr)) { using (DbContextTransaction transaction = contextNew.Database.BeginTransaction()) { try { var objTransaction = contextNew.TransactionMasters.Where(x => x.SlNo == TransactionId).FirstOrDefault(); var customerDetails = contextNew.CustomerDetails.Where(x => x.MobileNo == objTransaction.MobileNo).FirstOrDefault(); var PointExpiry = contextNew.PointsExpiries.Where(x => x.MobileNo == objTransaction.MobileNo && x.Status == "00").ToList(); var NewPointExpiry = contextNew.PointsExpiries.Where(x => x.MobileNo == objTransaction.MobileNo && x.Status == "00").OrderByDescending(y => y.ExpiryDate).FirstOrDefault(); var oldTransactionPoints = objTransaction.PointsEarned; objTransaction.PointsEarned = points; contextNew.TransactionMasters.AddOrUpdate(objTransaction); contextNew.SaveChanges(); foreach (var item in PointExpiry) { item.Status = "01"; contextNew.PointsExpiries.AddOrUpdate(item); contextNew.SaveChanges(); } PointsExpiry objPointExpiry = new PointsExpiry(); objPointExpiry.Points = (customerDetails.Points - oldTransactionPoints) + points; objPointExpiry.CounterId = NewPointExpiry.CounterId; objPointExpiry.MobileNo = NewPointExpiry.MobileNo; objPointExpiry.Datetime = DateTime.Now; objPointExpiry.EarnDate = NewPointExpiry.EarnDate; objPointExpiry.ExpiryDate = NewPointExpiry.ExpiryDate; objPointExpiry.Status = "00"; objPointExpiry.InvoiceNo = NewPointExpiry.InvoiceNo; objPointExpiry.GroupId = NewPointExpiry.GroupId; objPointExpiry.CustomerId = NewPointExpiry.CustomerId; contextNew.PointsExpiries.AddOrUpdate(objPointExpiry); contextNew.SaveChanges(); customerDetails.Points = (customerDetails.Points - oldTransactionPoints) + points; contextNew.CustomerDetails.AddOrUpdate(customerDetails); contextNew.SaveChanges(); using (var context = new CommonDBContext()) { context.tblAudits.Add(objAudit); context.SaveChanges(); } transaction.Commit(); status = true; } catch (Exception ex) { transaction.Rollback(); newexception.AddException(ex, GroupId); } } } return(status); }
public bool SubmitPoints(string MemberName, string Gender, string BirthDt, string mobileNo, string AnniversaryDt, string LiveIn, string Knowabt, string GroupId, string outletid) { bool status = false; // string smsresponce=""; List <FeedBackMaster> lstfeedback = new List <FeedBackMaster>(); TransactionMaster objtransactionMaster = new TransactionMaster(); PointsExpiry objpointsExpiry = new PointsExpiry(); CustomerDetail objnewcust = new CustomerDetail(); string connStr = objCustRepo.GetCustomerConnString(GroupId); TimeZoneInfo IND_ZONE = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"); DateTime date = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, IND_ZONE); using (var context = new BOTSDBContext(connStr)) { CustomerDetail objcustdetails = context.CustomerDetails.Where(x => x.MobileNo == mobileNo).FirstOrDefault(); OutletDetail objoutlet = context.OutletDetails.Where(x => x.OutletId == outletid).FirstOrDefault(); FeedBackMaster objfeedback = new FeedBackMaster(); lstfeedback = context.FeedBackMasters.Where(x => x.MobileNo == mobileNo).OrderByDescending(y => y.DOJ).Take(2).ToList(); if (objcustdetails != null) { if (AnniversaryDt != null) { objcustdetails.AnniversaryDate = Convert.ToDateTime(AnniversaryDt); } var point = objcustdetails.Points; objcustdetails.Points = point + objoutlet.FeedBackPoints; context.CustomerDetails.AddOrUpdate(objcustdetails); context.SaveChanges(); } if (objcustdetails == null) { var CustomerId = context.CustomerDetails.OrderByDescending(x => x.CustomerId).Select(y => y.CustomerId).FirstOrDefault(); DateTime datet = new DateTime(1900, 01, 01); var NewId = Convert.ToInt64(CustomerId) + 1; objnewcust.CustomerId = Convert.ToString(NewId); objnewcust.Points = objoutlet.FeedBackPoints; if (string.IsNullOrEmpty(MemberName)) { objnewcust.CustomerName = "Member"; } else { objnewcust.CustomerName = MemberName; } objnewcust.CustomerCategory = null; objnewcust.CardNumber = ""; objnewcust.CustomerThrough = "2"; if (BirthDt != "") { objnewcust.DOB = Convert.ToDateTime(BirthDt); } objnewcust.MaritalStatus = ""; objnewcust.MemberGroupId = "1000"; objnewcust.MobileNo = mobileNo; objnewcust.Status = "00"; if (AnniversaryDt != null) { objnewcust.AnniversaryDate = Convert.ToDateTime(AnniversaryDt); } objnewcust.DOJ = date; objnewcust.EmailId = ""; objnewcust.EnrollingOutlet = outletid; if (string.IsNullOrEmpty(Gender)) { objnewcust.Gender = ""; } else { objnewcust.Gender = Gender; } objnewcust.IsSMS = null; objnewcust.BillingCustomerId = null; context.CustomerDetails.Add(objnewcust); context.SaveChanges(); } if (objcustdetails != null) { objtransactionMaster.CustomerId = objcustdetails.CustomerId; objtransactionMaster.CustomerPoints = objcustdetails.Points; } else { objtransactionMaster.CustomerId = objnewcust.CustomerId; objtransactionMaster.CustomerPoints = objnewcust.Points; } objtransactionMaster.CounterId = outletid + "01"; objtransactionMaster.MobileNo = mobileNo; objtransactionMaster.Datetime = date; objtransactionMaster.TransType = "1"; objtransactionMaster.TransSource = "1"; if (GroupId != "1163") { objtransactionMaster.InvoiceNo = "B_Feedbackpoints"; } else { objtransactionMaster.InvoiceNo = "AabharBonus"; } objtransactionMaster.InvoiceAmt = 0; objtransactionMaster.Status = "06"; objtransactionMaster.PointsEarned = objoutlet.FeedBackPoints; objtransactionMaster.PointsBurned = 0; objtransactionMaster.CampaignPoints = 0; objtransactionMaster.TxnAmt = 0; objtransactionMaster.Synchronization = ""; objtransactionMaster.SyncDatetime = null; if (GroupId != "1163") { context.TransactionMasters.Add(objtransactionMaster); context.SaveChanges(); } if (lstfeedback.Count == 0 && GroupId == "1163") { context.TransactionMasters.Add(objtransactionMaster); context.SaveChanges(); } objpointsExpiry.MobileNo = mobileNo; objpointsExpiry.CounterId = outletid + "01"; if (objcustdetails != null) { objpointsExpiry.CustomerId = objcustdetails.CustomerId; } else { objpointsExpiry.CustomerId = objnewcust.CustomerId; } objpointsExpiry.BurnDate = null; objpointsExpiry.Datetime = date; objpointsExpiry.EarnDate = date; // DateTime today = date; DateTime next = date.AddYears(1); var currentmonth = DateTime.DaysInMonth(next.Year, next.Month); if (next.Day < currentmonth) { var days = (currentmonth - next.Day); next = date.AddDays(days).AddYears(1); } objpointsExpiry.ExpiryDate = next; objpointsExpiry.Points = objoutlet.FeedBackPoints; objpointsExpiry.Status = "00"; if (GroupId != "1163") { objpointsExpiry.InvoiceNo = "B_Feedbackpoints"; } else { objpointsExpiry.InvoiceNo = "AabharBonus"; } //objpointsExpiry.InvoiceNo = "B_Feedbackpoints"; objpointsExpiry.GroupId = objoutlet.GroupId; objpointsExpiry.OriginalInvoiceNo = ""; objpointsExpiry.TransRefNo = null; if (GroupId != "1163") { context.PointsExpiries.Add(objpointsExpiry); context.SaveChanges(); } if (lstfeedback.Count == 0 && GroupId == "1163") { context.PointsExpiries.Add(objpointsExpiry); context.SaveChanges(); } if (lstfeedback.Count == 0 && GroupId == "1163") { FeedBackMaster feedback = new FeedBackMaster(); feedback.MobileNo = mobileNo; feedback.CustomerName = MemberName; feedback.OutletId = outletid; feedback.Location = LiveIn; feedback.HowToKonwAbout = Knowabt; feedback.DOB = Convert.ToDateTime(BirthDt); if (AnniversaryDt != null) { feedback.DOA = Convert.ToDateTime(AnniversaryDt); } feedback.Points = objoutlet.FeedBackPoints; context.FeedBackMasters.AddOrUpdate(feedback); context.SaveChanges(); status = true; } else { foreach (var feedback in lstfeedback) { feedback.Location = LiveIn; feedback.HowToKonwAbout = Knowabt; if (BirthDt != "") { feedback.DOB = Convert.ToDateTime(BirthDt); } if (AnniversaryDt != null) { feedback.DOA = Convert.ToDateTime(AnniversaryDt); } feedback.Points = objoutlet.FeedBackPoints; context.FeedBackMasters.AddOrUpdate(feedback); context.SaveChanges(); status = true; } } if (status) { // string msgmobileno = "8452047477"; string message1; SMSDetail objsmsdetails = new SMSDetail(); FeedBackMobileMaster objmobilemaster = new FeedBackMobileMaster(); SMSEmailMaster objsmsemailmaster = new SMSEmailMaster(); if (GroupId != "1163") { objmobilemaster = context.FeedBackMobileMasters.Where(x => x.MessageId == "202").FirstOrDefault(); objsmsemailmaster = context.SMSEmailMasters.Where(x => x.MessageId == "202").FirstOrDefault(); string message = objsmsemailmaster.SMS; //TimeZoneInfo IND_ZONE = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"); //DateTime date = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, IND_ZONE); if (objcustdetails != null) { message = message.Replace("#01", objcustdetails.CustomerName); } else { message = message.Replace("#01", "Member"); } message = message.Replace("#30", mobileNo); message = message.Replace("#08", Convert.ToString(date)); objsmsdetails = context.SMSDetails.Where(x => x.OutletId == outletid).FirstOrDefault(); // SendBulkSMSMessageTxn(objmobilemaster.MobileNo, objsmsdetails.SenderId, message); SendBulkSMSMessagevision(objmobilemaster.MobileNo, objsmsdetails.SenderId, message); } objsmsemailmaster = context.SMSEmailMasters.Where(x => x.MessageId == "201").FirstOrDefault(); message1 = objsmsemailmaster.SMS; if (objcustdetails != null) { message1 = message1.Replace("#01", objcustdetails.CustomerName); } else { message1 = message1.Replace("#01", "Member"); } // SendMessage(mobileNo, objsmsdetails.SenderId, message1, objsmsdetails.TxnUrl, objsmsdetails.TxnUserName, objsmsdetails.TxnPassword); SendMessageVision(objsmsdetails.TxnUrl, mobileNo, message1, objsmsdetails.SenderId, objsmsdetails.TxnPassword); } } return(status); }
public string SubmitRating(string mobileNo, int[] ranking, string GroupId, string outletId) { string status = "false"; // string smsresponce = ""; FeedBackMaster objfeedback = new FeedBackMaster(); string connStr = objCustRepo.GetCustomerConnString(GroupId); TimeZoneInfo IND_ZONE = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"); DateTime date = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, IND_ZONE); using (var context = new BOTSDBContext(connStr)) { CustomerDetail objcustdetails = context.CustomerDetails.Where(x => x.MobileNo == mobileNo).FirstOrDefault(); OutletDetail objoutlet = context.OutletDetails.Where(x => x.OutletId == outletId).FirstOrDefault(); TransactionMaster objtransactionMaster = new TransactionMaster(); PointsExpiry objpointsExpiry = new PointsExpiry(); var transaction = context.TransactionMasters.Where(x => x.MobileNo == mobileNo).OrderByDescending(y => y.Datetime).Take(2).ToList(); var pointexpiry = context.PointsExpiries.Where(x => x.MobileNo == mobileNo).OrderByDescending(y => y.Datetime).Take(2).ToList(); int queid = 1; int Combinedpoint = 0; foreach (int points in ranking) { if (points != 0) { if (objcustdetails != null) { objfeedback.CustomerName = objcustdetails.CustomerName; } else { objfeedback.CustomerName = "Member"; } objfeedback.MobileNo = mobileNo; objfeedback.QuestionPoints = points.ToString(); objfeedback.QuestionId = queid.ToString(); objfeedback.OutletId = outletId; objfeedback.DOJ = date; Combinedpoint += points; objfeedback = context.FeedBackMasters.Add(objfeedback); context.SaveChanges(); status = "true"; } queid++; } if (Combinedpoint <= 4) { SMSDetail objsmsdetails = new SMSDetail(); FeedBackMobileMaster objmobilemaster = context.FeedBackMobileMasters.Where(x => x.MessageId == "203").FirstOrDefault(); SMSEmailMaster objsmsemailmaster = context.SMSEmailMasters.Where(x => x.MessageId == "203").FirstOrDefault(); string message = objsmsemailmaster.SMS; if (objcustdetails != null) { message = message.Replace("#01", objcustdetails.CustomerName); } else { message = message.Replace("#01", "Member"); } message = message.Replace("#30", mobileNo); message = message.Replace("#08", Convert.ToString(date)); message = message.Replace("#31", Convert.ToString(ranking[0])); message = message.Replace("#32", Convert.ToString(ranking[1])); objsmsdetails = context.SMSDetails.Where(x => x.OutletId == outletId).FirstOrDefault(); // SendMessage(objmobilemaster.MobileNo, objsmsdetails.SenderId, message, objsmsdetails.TxnUrl, objsmsdetails.TxnUserName, objsmsdetails.TxnPassword); SendMessageVision(objsmsdetails.TxnUrl, objmobilemaster.MobileNo, message, objsmsdetails.SenderId, objsmsdetails.TxnPassword); } if (transaction.Count > 0) { if (transaction[0].InvoiceNo == "B_Feedbackpoints" && pointexpiry[0].InvoiceNo == "B_Feedbackpoints") { var point = objcustdetails.Points; objcustdetails.Points = point + objoutlet.FeedBackPoints; context.CustomerDetails.AddOrUpdate(objcustdetails); context.SaveChanges(); objtransactionMaster.CustomerId = objcustdetails.CustomerId; objtransactionMaster.CustomerPoints = objcustdetails.Points; objtransactionMaster.CounterId = outletId + "01"; objtransactionMaster.MobileNo = mobileNo; objtransactionMaster.Datetime = date; objtransactionMaster.TransType = "1"; objtransactionMaster.TransSource = "1"; objtransactionMaster.InvoiceNo = "B_Feedbackpoints"; objtransactionMaster.InvoiceAmt = 0; objtransactionMaster.Status = "06"; objtransactionMaster.PointsEarned = objoutlet.FeedBackPoints; objtransactionMaster.PointsBurned = 0; objtransactionMaster.CampaignPoints = 0; objtransactionMaster.TxnAmt = 0; objtransactionMaster.Synchronization = ""; objtransactionMaster.SyncDatetime = null; context.TransactionMasters.Add(objtransactionMaster); context.SaveChanges(); objpointsExpiry.MobileNo = mobileNo; objpointsExpiry.CounterId = outletId + "01"; objpointsExpiry.CustomerId = objcustdetails.CustomerId; objpointsExpiry.BurnDate = null; objpointsExpiry.Datetime = date; objpointsExpiry.EarnDate = date; // DateTime today = date; DateTime next = date.AddYears(1); var currentmonth = DateTime.DaysInMonth(next.Year, next.Month); if (next.Day < currentmonth) { var days = (currentmonth - next.Day); next = date.AddDays(days).AddYears(1); } objpointsExpiry.ExpiryDate = next; objpointsExpiry.Points = objoutlet.FeedBackPoints; objpointsExpiry.Status = "00"; objpointsExpiry.InvoiceNo = "B_Feedbackpoints"; objpointsExpiry.GroupId = objoutlet.GroupId; objpointsExpiry.OriginalInvoiceNo = ""; objpointsExpiry.TransRefNo = null; context.PointsExpiries.Add(objpointsExpiry); context.SaveChanges(); status = "pointsGiven"; } } } return(status); }
public int AddpointsToExistingCust(string mobileNo, string BeneficiaryId, string Name) { int result = 0; CustomerDetails objcustomerDetails = new CustomerDetails(); List <TransactionMaster> lsttransaction = new List <TransactionMaster>(); TransactionMaster objtransactionMaster = new TransactionMaster(); PointsExpiry objpointsExpiry = new PointsExpiry(); List <PointsExpiry> lstpointsExpiry = new List <PointsExpiry>(); try { using (var contextNew = new ChitaleBCContext()) { CustomerBeneficiaryDetail objcustomerBeneficiaryDetail = new CustomerBeneficiaryDetail(); objcustomerBeneficiaryDetail = contextNew.CustomerBeneficiaryDetails.Where(x => x.MobileNo == mobileNo).FirstOrDefault(); objcustomerDetails = contextNew.CustomerDetails.Where(x => x.MobileNo == mobileNo).FirstOrDefault(); if (objcustomerBeneficiaryDetail != null) { result = 0; } else { objcustomerBeneficiaryDetail = contextNew.CustomerBeneficiaryDetails.Where(x => x.BeneficiaryId == BeneficiaryId).FirstOrDefault(); if (objcustomerBeneficiaryDetail != null) { result = 1; } else { if (objcustomerDetails != null) { var point = objcustomerDetails.Points; objcustomerDetails.Points = point + 100; contextNew.CustomerDetails.AddOrUpdate(objcustomerDetails); contextNew.SaveChanges(); objtransactionMaster.CustomerId = objcustomerDetails.CustomerId; objtransactionMaster.CounterId = "1088101001"; objtransactionMaster.MobileNo = mobileNo; objtransactionMaster.Datetime = DateTime.Now; objtransactionMaster.TransType = "1"; objtransactionMaster.TransSource = "1"; objtransactionMaster.InvoiceNo = "B_CovidPoints"; objtransactionMaster.InvoiceAmt = 0; objtransactionMaster.Status = "06"; objtransactionMaster.PointsEarned = 100; objtransactionMaster.PointsBurned = 0; objtransactionMaster.CampaignPoints = 0; objtransactionMaster.TxnAmt = 0; objtransactionMaster.CustomerPoints = objcustomerDetails.Points; objtransactionMaster.Synchronization = ""; objtransactionMaster.SyncDatetime = null; objtransactionMaster.BillType = ""; objtransactionMaster.ChitaleTxnStatus = ""; contextNew.TransactionMasters.Add(objtransactionMaster); contextNew.SaveChanges(); lstpointsExpiry = contextNew.PointsExpiries.Where(x => x.MobileNo == mobileNo).ToList(); objpointsExpiry.MobileNo = mobileNo; objpointsExpiry.CounterId = "1088101001"; objpointsExpiry.CustomerId = objcustomerDetails.CustomerId; objpointsExpiry.BurnDate = null; objpointsExpiry.Datetime = DateTime.Now; objpointsExpiry.EarnDate = DateTime.Now; DateTime today = DateTime.Today; DateTime next = today.AddYears(1); var currentmonth = DateTime.DaysInMonth(next.Year, next.Month); if (next.Day < currentmonth) { var days = (currentmonth - next.Day); next = today.AddDays(days).AddYears(1); } objpointsExpiry.ExpiryDate = next; objpointsExpiry.Points = 100; objpointsExpiry.Status = "00"; objpointsExpiry.InvoiceNo = "B_CovidPoints"; objpointsExpiry.GroupId = "1088"; objpointsExpiry.OriginalInvoiceNo = ""; objpointsExpiry.TransRefNo = null; contextNew.PointsExpiries.Add(objpointsExpiry); contextNew.SaveChanges(); CustomerBeneficiaryDetail objcustomerBeneficiaryDetail1 = new CustomerBeneficiaryDetail(); objcustomerBeneficiaryDetail1.BeneficiaryId = BeneficiaryId; objcustomerBeneficiaryDetail1.CustomerId = objcustomerDetails.CustomerId; objcustomerBeneficiaryDetail1.CustomerName = Name; objcustomerBeneficiaryDetail1.MobileNo = mobileNo; objcustomerBeneficiaryDetail1.Points = Convert.ToDecimal(objcustomerDetails.Points); objcustomerBeneficiaryDetail1.EnrolledDate = DateTime.Now; contextNew.CustomerBeneficiaryDetails.Add(objcustomerBeneficiaryDetail1); contextNew.SaveChanges(); result = 2; } else { CustomerDetails objcustomerDetail = new CustomerDetails(); CustomerBeneficiaryDetail objcustomerBeneficiaryDetails = new CustomerBeneficiaryDetail(); var ObjMobileNo = contextNew.CustomerDetails.Where(x => x.MobileNo == mobileNo).FirstOrDefault(); if (ObjMobileNo == null) { var CustomerId = contextNew.CustomerDetails.OrderByDescending(x => x.CustomerId).Select(y => y.CustomerId).FirstOrDefault(); DateTime datet = new DateTime(1900, 01, 01); var NewId = Convert.ToInt64(CustomerId) + 1; objcustomerDetail.CustomerId = Convert.ToString(NewId); objcustomerDetail.Points = 100; objcustomerDetail.CustomerName = Name; objcustomerDetail.CustomerCategory = null; objcustomerDetail.CardNumber = ""; objcustomerDetail.CustomerThrough = "2"; objcustomerDetail.DOB = datet; objcustomerDetail.MaritalStatus = ""; objcustomerDetail.MemberGroupId = "1000"; objcustomerDetail.MobileNo = mobileNo; objcustomerDetail.Status = "00"; objcustomerDetail.AnniversaryDate = datet; objcustomerDetail.DOJ = DateTime.Now; objcustomerDetail.EmailId = ""; objcustomerDetail.EnrollingOutlet = "10881010"; objcustomerDetail.Gender = ""; objcustomerDetail.IsSMS = null; objcustomerDetail.BillingCustomerId = null; //objcustomerDetails. contextNew.CustomerDetails.Add(objcustomerDetail); contextNew.SaveChanges(); objtransactionMaster.CustomerId = objcustomerDetail.CustomerId; objtransactionMaster.CounterId = "1088101001"; objtransactionMaster.MobileNo = mobileNo; objtransactionMaster.Datetime = DateTime.Now; objtransactionMaster.TransType = "1"; objtransactionMaster.TransSource = "1"; objtransactionMaster.InvoiceNo = "B_CovidPoints"; objtransactionMaster.InvoiceAmt = 0; objtransactionMaster.Status = "06"; objtransactionMaster.PointsEarned = 100; objtransactionMaster.PointsBurned = 0; objtransactionMaster.CampaignPoints = 0; objtransactionMaster.TxnAmt = 0; objtransactionMaster.CustomerPoints = objcustomerDetail.Points; objtransactionMaster.Synchronization = ""; objtransactionMaster.SyncDatetime = null; objtransactionMaster.BillType = ""; objtransactionMaster.ChitaleTxnStatus = ""; contextNew.TransactionMasters.AddOrUpdate(objtransactionMaster); contextNew.SaveChanges(); lstpointsExpiry = contextNew.PointsExpiries.Where(x => x.MobileNo == mobileNo).ToList(); objpointsExpiry.MobileNo = mobileNo; objpointsExpiry.CounterId = "1088101001"; objpointsExpiry.CustomerId = objcustomerDetail.CustomerId; objpointsExpiry.BurnDate = null; objpointsExpiry.Datetime = DateTime.Now; objpointsExpiry.EarnDate = DateTime.Now; DateTime today = DateTime.Today; DateTime next = today.AddYears(1); var currentmonth = DateTime.DaysInMonth(next.Year, next.Month); if (next.Day < currentmonth) { var days = (currentmonth - next.Day); next = today.AddDays(days).AddYears(1); } objpointsExpiry.ExpiryDate = next; objpointsExpiry.Points = 100; objpointsExpiry.Status = "00"; objpointsExpiry.InvoiceNo = "B_CovidPoints"; objpointsExpiry.GroupId = "1088"; objpointsExpiry.OriginalInvoiceNo = ""; objpointsExpiry.TransRefNo = null; contextNew.PointsExpiries.AddOrUpdate(objpointsExpiry); contextNew.SaveChanges(); objcustomerBeneficiaryDetails.BeneficiaryId = BeneficiaryId; objcustomerBeneficiaryDetails.CustomerId = objcustomerDetail.CustomerId; objcustomerBeneficiaryDetails.CustomerName = Name; objcustomerBeneficiaryDetails.MobileNo = mobileNo; objcustomerBeneficiaryDetails.Points = Convert.ToDecimal(objcustomerDetail.Points); objcustomerBeneficiaryDetails.EnrolledDate = DateTime.Now; contextNew.CustomerBeneficiaryDetails.AddOrUpdate(objcustomerBeneficiaryDetails); contextNew.SaveChanges(); result = 2; } } } } } } catch (Exception ex) { //newexception.AddException(ex); } return(result); }