public bool UpdateNameOfMember(string GroupId, string CustomerId, string Name, tblAudit objAudit) { bool status = false; try { CustomerDetail objCustomerDetail = new CustomerDetail(); string connStr = objCustRepo.GetCustomerConnString(GroupId); using (var contextNew = new BOTSDBContext(connStr)) { objCustomerDetail = contextNew.CustomerDetails.Where(x => x.CustomerId == CustomerId).FirstOrDefault(); objCustomerDetail.CustomerName = Name; contextNew.CustomerDetails.AddOrUpdate(objCustomerDetail); contextNew.SaveChanges(); status = true; } using (var context = new CommonDBContext()) { context.tblAudits.Add(objAudit); context.SaveChanges(); } } catch (Exception ex) { newexception.AddException(ex, ""); } return(status); }
public bool UpdateSecurityKey(string GroupId, string counterId) { bool result = false; try { StoreDetail objstore = new StoreDetail(); string connStr = objCustRepo.GetCustomerConnString(GroupId); using (var contextNew = new BOTSDBContext(connStr)) { objstore = contextNew.StoreDetails.Where(x => x.CounterId == counterId).FirstOrDefault(); objstore.Status = "01"; contextNew.StoreDetails.AddOrUpdate(objstore); contextNew.SaveChanges(); result = true; } } catch (Exception ex) { newexception.AddException(ex, ""); } return(result); }
public SPResponse AddLoadBonusData(string GroupId, string MobileNo, string OutletId, int BonusPoints, string BonusRemark, DateTime ExpiryDate, string IsSMS, tblAudit objAudit) { SPResponse result = new SPResponse(); try { string connStr = objCustRepo.GetCustomerConnString(GroupId); using (var contextNew = new BOTSDBContext(connStr)) { result = contextNew.Database.SqlQuery <SPResponse>("sp_BonusPoints_ITOPS @pi_MobileNo, @pi_OutletId, @pi_RequestDate, @pi_ExpiryDate, @pi_BonusRemarks, @pi_BonusPoints,@pi_LoginId, @pi_RequestBy, @pi_RequestedOnForum, @pi_SMSFlag", new SqlParameter("@pi_MobileNo", MobileNo), new SqlParameter("@pi_OutletId", OutletId), new SqlParameter("@pi_RequestDate", objAudit.RequestedOn.ToString("yyyy-MM-dd")), new SqlParameter("@pi_ExpiryDate", ExpiryDate.ToString("yyyy-MM-dd")), new SqlParameter("@pi_BonusRemarks", BonusRemark), new SqlParameter("@pi_BonusPoints", BonusPoints), new SqlParameter("@pi_LoginId", ""), new SqlParameter("@pi_RequestBy", objAudit.RequestedBy), new SqlParameter("@pi_RequestedOnForum", objAudit.RequestedOnForum), new SqlParameter("@pi_SMSFlag", IsSMS)).FirstOrDefault <SPResponse>(); } using (var context = new CommonDBContext()) { context.tblAudits.Add(objAudit); context.SaveChanges(); } } catch (Exception ex) { newexception.AddException(ex, GroupId); } return(result); }
public SPResponse AddRedeemPointsData(string GroupId, string MobileNo, string OutletId, DateTime TxnDate, DateTime RequestDate, string InvoiceNo, string InvoiceAmt, decimal Points, string IsSMS, string TxnType, tblAudit objAudit) { SPResponse result = new SPResponse(); try { string connStr = objCustRepo.GetCustomerConnString(GroupId); using (var contextNew = new BOTSDBContext(connStr)) { result = contextNew.Database.SqlQuery <SPResponse>("sp_BurnRW_New_ITOPS @pi_MobileNo, @pi_OutletId, @pi_TxnDate, @pi_RequestDate, @pi_InvoiceNo, @pi_InvoiceAmt,@pi_RedeemPoints, @pi_LoginId, @pi_RequestBy, @pi_RequestedOnForum, @pi_SMSFlag, @pi_TxnType", new SqlParameter("@pi_MobileNo", MobileNo), new SqlParameter("@pi_OutletId", OutletId), new SqlParameter("@pi_TxnDate", TxnDate.ToString("yyyy-MM-dd")), new SqlParameter("@pi_RequestDate", RequestDate.ToString("yyyy-MM-dd")), new SqlParameter("@pi_InvoiceNo", InvoiceNo), new SqlParameter("@pi_InvoiceAmt", InvoiceAmt), new SqlParameter("@pi_RedeemPoints", Points), new SqlParameter("@pi_LoginId", ""), new SqlParameter("@pi_RequestBy", objAudit.RequestedBy), new SqlParameter("@pi_RequestedOnForum", objAudit.RequestedOnForum), new SqlParameter("@pi_SMSFlag", IsSMS), new SqlParameter("@pi_TxnType", TxnType)).FirstOrDefault <SPResponse>(); } using (var context = new CommonDBContext()) { context.tblAudits.Add(objAudit); context.SaveChanges(); } } catch (Exception ex) { newexception.AddException(ex, GroupId); } return(result); }
public DashboardMemberSegment GetDashboardMemberSegmentData(string GroupId, string OutletId, string connstr) { DashboardMemberSegment dashboardMemberSegment = new DashboardMemberSegment(); using (var context = new BOTSDBContext(connstr)) { dashboardMemberSegment = context.Database.SqlQuery <DashboardMemberSegment>("sp_BOTS_DashboardMemberSegment @pi_GroupId, @pi_Date, @pi_OutletId", new SqlParameter("@pi_GroupId", GroupId), new SqlParameter("@pi_Date", DateTime.Now.ToString("yyyy-MM-dd")), new SqlParameter("@pi_OutletId", OutletId)).FirstOrDefault <DashboardMemberSegment>(); DateTime?FromDate; if (!string.IsNullOrEmpty(OutletId)) { OutletId = OutletId + "01"; FromDate = context.TransactionMasters.Where(x => x.CounterId == OutletId).OrderBy(y => y.Datetime).Select(z => z.Datetime).FirstOrDefault(); } else { FromDate = context.TransactionMasters.OrderBy(y => y.Datetime).Select(z => z.Datetime).FirstOrDefault(); } if (FromDate.HasValue) { dashboardMemberSegment.FromDate = FromDate.Value.ToString("MM-dd-yyyy"); dashboardMemberSegment.ToDate = DateTime.Now.ToString("MM-dd-yyyy"); } } return(dashboardMemberSegment); }
public List <CampaignInactiveData> GetCampaignInactiveSecondData(string GroupId, string connstr, string month, string year) { List <CampaignInactiveData> objCampaignInactiveData = new List <CampaignInactiveData>(); try { using (var context = new BOTSDBContext(connstr)) { objCampaignInactiveData = context.Database.SqlQuery <CampaignInactiveData>("sp_BOTS_CM_InActive1 @pi_GroupId, @pi_Date, @pi_LoginId, @pi_Month, @pi_Year", new SqlParameter("@pi_GroupId", GroupId), new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()), new SqlParameter("@pi_LoginId", ""), new SqlParameter("@pi_Month", month), new SqlParameter("@pi_Year", year)).ToList <CampaignInactiveData>(); if (objCampaignInactiveData != null) { foreach (var item in objCampaignInactiveData) { item.InActiveDateStr = item.InActiveDate.Value.ToString("yyyy-MM-dd"); item.TxnDateStr = item.TxnDate.Value.ToString("yyyy-MM-dd"); } } } } catch (Exception ex) { newexception.AddException(ex, GroupId); } return(objCampaignInactiveData); }
public bool ChangeSMSDetails(string GroupId, string CustomerId, bool Disable, tblAudit objAudit) { bool status = false; try { string connStr = objCustRepo.GetCustomerConnString(GroupId); using (var contextNew = new BOTSDBContext(connStr)) { var objCustomer = contextNew.CustomerDetails.Where(x => x.CustomerId == CustomerId).FirstOrDefault(); objCustomer.IsSMS = Disable; contextNew.CustomerDetails.AddOrUpdate(objCustomer); contextNew.SaveChanges(); status = true; } using (var context = new CommonDBContext()) { context.tblAudits.Add(objAudit); context.SaveChanges(); } } catch (Exception ex) { newexception.AddException(ex, GroupId); } return(status); }
public SPResponse AddBulkCustomerData(string GroupId, CustomerDetail objCustomer) { SPResponse result = new SPResponse(); try { string connStr = objCustRepo.GetCustomerConnString(GroupId); using (var contextNew = new BOTSDBContext(connStr)) { var ObjMobileNo = contextNew.CustomerDetails.Where(x => x.MobileNo == objCustomer.MobileNo).FirstOrDefault(); if (ObjMobileNo == null) { var CustomerId = contextNew.CustomerDetails.OrderByDescending(x => x.CustomerId).Select(y => y.CustomerId).FirstOrDefault(); var NewId = Convert.ToInt64(CustomerId) + 1; objCustomer.CustomerId = Convert.ToString(NewId); contextNew.CustomerDetails.AddOrUpdate(objCustomer); contextNew.SaveChanges(); result.ResponseCode = "00"; result.ResponseMessage = "Member Added Successfully"; } else { result.ResponseCode = "01"; result.ResponseMessage = "Mobile Number Already Exist"; } } } catch (Exception ex) { newexception.AddException(ex, GroupId); } return(result); }
public MemberData GetOTPData(string GroupId, string MobileNo) { MemberData objMemberData = new MemberData(); try { CustomerDetail objCustomerDetail = new CustomerDetail(); OTPMaintenance objOTP = new OTPMaintenance(); string connStr = objCustRepo.GetCustomerConnString(GroupId); using (var contextNew = new BOTSDBContext(connStr)) { objOTP = contextNew.OTPMaintenances.Where(x => x.MobileNo == MobileNo).OrderByDescending(y => y.Datetime).FirstOrDefault(); } if (objOTP != null) { objMemberData.MobileNo = objOTP.OTP; objMemberData.EnrolledOn = Convert.ToString(objOTP.Datetime); var OutletId = objOTP.CounterId.Substring(0, objOTP.CounterId.Length - 2); using (var contextNew = new BOTSDBContext(connStr)) { objMemberData.EnrolledOutletName = contextNew.OutletDetails.Where(x => x.OutletId == OutletId).Select(y => y.OutletName).FirstOrDefault(); } } } catch (Exception ex) { newexception.AddException(ex, GroupId); } return(objMemberData); }
public CancelTxnModel GetTransactionByInvoiceNoAndMobileNo(string GroupId, string MobileNo, string InvoiceNo) { CancelTxnModel objReturn = new CancelTxnModel(); try { TransactionMaster objTxn = new TransactionMaster(); CustomerDetail objCustomerDetail = new CustomerDetail(); string connStr = objCustRepo.GetCustomerConnString(GroupId); using (var contextNew = new BOTSDBContext(connStr)) { objTxn = contextNew.TransactionMasters.Where(x => x.InvoiceNo == InvoiceNo && x.MobileNo == MobileNo && x.Status == "06").FirstOrDefault(); } if (objTxn != null) { objReturn.InvoiceNo = objTxn.InvoiceNo; objReturn.InvoiceAmt = objTxn.InvoiceAmt; objReturn.MobileNo = objTxn.MobileNo; objReturn.Points = Convert.ToString(objTxn.PointsEarned); objReturn.Datetime = Convert.ToDateTime(objTxn.Datetime).ToString("dd/MM/yyyy HH:mm:ss"); objReturn.DatetimeOriginal = Convert.ToString(objTxn.Datetime); var OutletId = objTxn.CounterId.Substring(0, objTxn.CounterId.Length - 2); using (var contextNew = new BOTSDBContext(connStr)) { objReturn.OutletName = contextNew.OutletDetails.Where(x => x.OutletId == OutletId).Select(y => y.OutletName).FirstOrDefault(); objReturn.TransactionName = contextNew.TransactionTypeMasters.Where(x => x.TransactionType == objTxn.TransType).Select(y => y.TransactionName).FirstOrDefault(); } } } catch (Exception ex) { newexception.AddException(ex, GroupId); } return(objReturn); }
public SPResponse DeleteTransaction(string GroupId, string InvoiceNo, string MobileNo, string InvoiceAmt, DateTime ip_Date, tblAudit objAudit) { SPResponse result = new SPResponse(); try { string connStr = objCustRepo.GetCustomerConnString(GroupId); using (var contextNew = new BOTSDBContext(connStr)) { result = contextNew.Database.SqlQuery <SPResponse>("sp_CancelTxn1_ITOPS @pi_MobileNo, @pi_InvoiceNo, @pi_InvoiceAmt, @pi_RequestDate, @pi_Datetime, @pi_LoginId,@pi_RequestBy, @pi_RequestedOnForum, @pi_SMSFlag", new SqlParameter("@pi_MobileNo", MobileNo), new SqlParameter("@pi_InvoiceNo", InvoiceNo), new SqlParameter("@pi_InvoiceAmt", InvoiceAmt), new SqlParameter("@pi_RequestDate", objAudit.RequestedOn), new SqlParameter("@pi_Datetime", ip_Date), new SqlParameter("@pi_LoginId", ""), new SqlParameter("@pi_RequestBy", objAudit.RequestedBy), new SqlParameter("@pi_RequestedOnForum", objAudit.RequestedOnForum), new SqlParameter("@pi_SMSFlag", "0")).FirstOrDefault <SPResponse>(); } using (var context = new CommonDBContext()) { context.tblAudits.Add(objAudit); context.SaveChanges(); } } catch (Exception ex) { newexception.AddException(ex, GroupId); } return(result); }
public SMSConfig GetSMSEmailMasterDetails(string groupId) { SMSConfig objData = new SMSConfig(); try { var connectionString = GetCustomerConnString(groupId); using (var contextNew = new BOTSDBContext(connectionString)) { var lstSMSEmail = contextNew.SMSEmailMasters.ToList(); if (lstSMSEmail != null) { objData.Enrollment = lstSMSEmail.Where(x => x.MessageId == "100").Select(y => y.SMS).FirstOrDefault(); objData.Earn = lstSMSEmail.Where(x => x.MessageId == "101").Select(y => y.SMS).FirstOrDefault(); objData.Burn = lstSMSEmail.Where(x => x.MessageId == "102").Select(y => y.SMS).FirstOrDefault(); objData.CancelEarn = lstSMSEmail.Where(x => x.MessageId == "103").Select(y => y.SMS).FirstOrDefault(); objData.CancelBurn = lstSMSEmail.Where(x => x.MessageId == "104").Select(y => y.SMS).FirstOrDefault(); objData.OTP = lstSMSEmail.Where(x => x.MessageId == "105").Select(y => y.SMS).FirstOrDefault(); objData.BalanceInquiry = lstSMSEmail.Where(x => x.MessageId == "106").Select(y => y.SMS).FirstOrDefault(); objData.EnrollmentAndEarn = lstSMSEmail.Where(x => x.MessageId == "107").Select(y => y.SMS).FirstOrDefault(); } } } catch (Exception ex) { } return(objData); }
public SMSDetail GetAllSMSDetails(string groupId) { SMSDetail SMSDetails = new SMSDetail(); var connectionString = GetCustomerConnString(groupId); try { using (var contextNew = new BOTSDBContext(connectionString)) { var lstSMSDetails = contextNew.SMSDetails.ToList(); if (lstSMSDetails != null) { if (lstSMSDetails.Count == 1) { SMSDetails = lstSMSDetails.ElementAt(0); } } } } catch (Exception ex) { newexception.AddException(ex, ""); } return(SMSDetails); }
public List <TelecallerReport> GetTelecallerReportData(DateTime fromdt, DateTime todate, string connstr, string GroupId) { List <TelecallerReport> lsttelereportdata = new List <TelecallerReport>(); todate = todate.AddDays(1).Date.AddSeconds(-1); try { using (var context = new BOTSDBContext(connstr)) { lsttelereportdata = (from t in context.TelecallerTrackings join o in context.OutletDetails on t.OutletId equals o.OutletId where t.AddedDate > fromdt && t.AddedDate < todate select new TelecallerReport { MobileNo = t.MobileNo, CustomerName = t.CustomerName, Gender = t.Gender, DOB = t.DOB, DOA = t.DOA, Points = t.Points, OutletId = t.OutletId, OutletName = o.OutletName, IsSMSSend = t.IsSMSSend, Comments = t.Comments, AddedBy = t.AddedBy, AddedDate = t.AddedDate }).ToList(); } using (var context = new CommonDBContext()) { lsttelereportdata = (from t in lsttelereportdata join c in context.CustomerLoginDetails on t.AddedBy equals c.LoginId select new TelecallerReport { MobileNo = t.MobileNo, CustomerName = t.CustomerName, Gender = t.Gender, DOB = t.DOB, DOA = t.DOA, Points = t.Points, OutletId = t.OutletId, OutletName = t.OutletName, IsSMSSend = t.IsSMSSend, Comments = t.Comments, AddedBy = c.UserName, AddedDate = t.AddedDate }).ToList(); } } catch (Exception ex) { newexception.AddException(ex, GroupId); } return(lsttelereportdata); }
public List <DashboardOutletEnrolment> GetDashboardOutletEnrolmentData(string GroupId, string monthFlag, string connstr) { List <DashboardOutletEnrolment> dashboardOutletEnrolment = new List <DashboardOutletEnrolment>(); using (var context = new BOTSDBContext(connstr)) { dashboardOutletEnrolment = context.Database.SqlQuery <DashboardOutletEnrolment>("sp_BOTS_DashboardOutletEnrolment @pi_GroupId, @pi_Date, @pi_Flag", new SqlParameter("@pi_GroupId", GroupId), new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()), new SqlParameter("@pi_Flag", monthFlag)).OrderByDescending(s => s.EnrollmentCount).ToList <DashboardOutletEnrolment>(); } return(dashboardOutletEnrolment); }
public DashboardMemberWebPage GetDashboardMemberWebPageData(string GroupId, string profileFlag, string connstr) { DashboardMemberWebPage dashboardMemberWebPage = new DashboardMemberWebPage(); using (var context = new BOTSDBContext(connstr)) { dashboardMemberWebPage = context.Database.SqlQuery <DashboardMemberWebPage>("sp_BOTS_DashboardMemberWebPage @pi_GroupId, @pi_Date, @pi_Flag", new SqlParameter("@pi_GroupId", GroupId), new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()), new SqlParameter("@pi_Flag", profileFlag)).FirstOrDefault <DashboardMemberWebPage>(); } return(dashboardMemberWebPage); }
public DashboardPointsSummary GetDashboardPointsSummaryData(string GroupId, string monthFlag, string connstr, string loginId) { DashboardPointsSummary dashboardPointsSummary = new DashboardPointsSummary(); using (var context = new BOTSDBContext(connstr)) { dashboardPointsSummary = context.Database.SqlQuery <DashboardPointsSummary>("sp_BOTS_DashboardPointsSummary @pi_GroupId, @pi_Date, @pi_Flag, @pi_LoginId", new SqlParameter("@pi_GroupId", GroupId), new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()), new SqlParameter("@pi_Flag", monthFlag), new SqlParameter("@pi_LoginId", loginId)).FirstOrDefault <DashboardPointsSummary>(); } return(dashboardPointsSummary); }
public DLCCreation GetDLCForEdit(long SlNo, string GroupId) { DLCCreation objData = new DLCCreation(); var connStr = CR.GetCustomerConnString(GroupId); using (var context = new BOTSDBContext(connStr)) { objData = context.DLCCreations.Where(x => x.SlNo == SlNo).FirstOrDefault(); } return(objData); }
public DashboardBulkUpload GetDashboardBulkUpload(string GroupId, string connstr) { DashboardBulkUpload objDashboardBulkUpload = new DashboardBulkUpload(); using (var context = new BOTSDBContext(connstr)) { objDashboardBulkUpload = context.Database.SqlQuery <DashboardBulkUpload>("sp_BOTS_DashboardBulkUpload @pi_GroupId, @pi_Date, @pi_LoginId", new SqlParameter("@pi_GroupId", GroupId), new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()), new SqlParameter("@pi_LoginId", "")).FirstOrDefault <DashboardBulkUpload>(); } return(objDashboardBulkUpload); }
public List <DLCCreation> GetDLCCreationData(string GroupId) { List <DLCCreation> lstData = new List <DLCCreation>(); var connectionString = CR.GetCustomerConnString(GroupId); using (var context = new BOTSDBContext(connectionString)) { lstData = context.DLCCreations.ToList(); } return(lstData); }
public int GetDLCRecordCount(string GroupId) { int count = 0; var connStr = CR.GetCustomerConnString(GroupId); using (var context = new BOTSDBContext(connStr)) { count = context.DLCCreations.Count(); } return(count); }
public DashboardRedemption GetDashboardRedemption(string GroupId, string Type, string connstr) { DashboardRedemption objDashboardRedemption = new DashboardRedemption(); using (var context = new BOTSDBContext(connstr)) { objDashboardRedemption = context.Database.SqlQuery <DashboardRedemption>("sp_BOTS_DashboardRedemption @pi_GroupId, @pi_Date, @pi_LoginId, @pi_Type", new SqlParameter("@pi_GroupId", GroupId), new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()), new SqlParameter("@pi_LoginId", ""), new SqlParameter("@pi_Type", Type)).FirstOrDefault <DashboardRedemption>(); } return(objDashboardRedemption); }
public List <DashboardBizShared> GetDashboardBizShared(string GroupId, string OutletId, string connstr) { List <DashboardBizShared> lstBizShared = new List <DashboardBizShared>(); using (var context = new BOTSDBContext(connstr)) { lstBizShared = context.Database.SqlQuery <DashboardBizShared>("sp_BOTS_DashboardBizShared @pi_GroupId, @pi_Date, @pi_LoginId, @pi_OutletId", new SqlParameter("@pi_GroupId", GroupId), new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()), new SqlParameter("@pi_LoginId", ""), new SqlParameter("@pi_OutletId", OutletId)).ToList <DashboardBizShared>(); } return(lstBizShared); }
public List <BrandDetail> GetAllBrandsByGroupId(string GroupId) { List <BrandDetail> lstBrands = new List <BrandDetail>(); string ConnectionString = string.Empty; using (var context = new CommonDBContext()) { var DBDetails = context.DatabaseDetails.Where(x => x.GroupId == GroupId).FirstOrDefault(); ConnectionString = "Data Source = " + DBDetails.IPAddress + "; Initial Catalog = " + DBDetails.DBName + "; user id = " + DBDetails.DBId + "; password = "******""; } using (var contextNew = new BOTSDBContext(ConnectionString)) { lstBrands = contextNew.BrandDetails.Where(x => x.GroupId == GroupId).ToList(); } return(lstBrands); }
public long GetMemberBase(string GroupId) { long MemberBase = 0; string ConnectionString = string.Empty; using (var context = new CommonDBContext()) { var DBDetails = context.DatabaseDetails.Where(x => x.GroupId == GroupId).FirstOrDefault(); ConnectionString = "Data Source = " + DBDetails.IPAddress + "; Initial Catalog = " + DBDetails.DBName + "; user id = " + DBDetails.DBId + "; password = "******""; using (var contextNew = new BOTSDBContext(ConnectionString)) { MemberBase = contextNew.CustomerDetails.Count(); } } return(MemberBase); }
public List <LogDetailsRW> GetLogDetails(string search, string GroupId) { List <LogDetailsRW> lstLogDetails = new List <LogDetailsRW>(); string connStr = objCustRepo.GetCustomerConnString(GroupId); using (var contextNew = new BOTSDBContext(connStr)) { lstLogDetails = contextNew.LogDetailsRWs.Where(x => x.ReceivedData.Contains(search)).ToList(); } foreach (var item in lstLogDetails) { item.datetimestr = item.Datetime.Value.ToString("MM/dd/yyyy"); } lstLogDetails = lstLogDetails.OrderByDescending(x => x.Datetime).ToList(); return(lstLogDetails); }
public List <SellingProductValue> GetBottom5SellingProductValue(string GroupId, string connstr) { List <SellingProductValue> lstBottom5SessingProductValue = new List <SellingProductValue>(); try { using (var context = new BOTSDBContext(connstr)) { lstBottom5SessingProductValue = context.Database.SqlQuery <SellingProductValue>("sp_BOTS_Bottom5_SellingProductValue").ToList <SellingProductValue>(); } } catch (Exception ex) { newexception.AddException(ex, GroupId); } return(lstBottom5SessingProductValue); }
public List <MWPSourceMaster> GetMWPSourceMaster(string groupId) { List <MWPSourceMaster> objData = new List <MWPSourceMaster>(); try { var connectionString = GetCustomerConnString(groupId); using (var contextNew = new BOTSDBContext(connectionString)) { objData = contextNew.MWPSourceMasters.ToList(); } } catch (Exception ex) { } return(objData); }
public List <MWP_Details> GetDLCDetails(string groupId) { List <MWP_Details> lstData = new List <MWP_Details>(); try { var connectionString = GetCustomerConnString(groupId); using (var contextNew = new BOTSDBContext(connectionString)) { lstData = contextNew.MWP_Details.ToList(); } } catch (Exception ex) { } return(lstData); }
public CustomerDetail GetCustomerByMobileNo(string GroupId, string MobileNo) { CustomerDetail objCustomerDetail = new CustomerDetail(); try { string connStr = objCustRepo.GetCustomerConnString(GroupId); using (var contextNew = new BOTSDBContext(connStr)) { objCustomerDetail = contextNew.CustomerDetails.Where(x => x.MobileNo == MobileNo).FirstOrDefault(); } } catch (Exception ex) { newexception.AddException(ex, GroupId); } return(objCustomerDetail); }