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