public FileContentResult SubscriptionExportToExcel(int?customerId, int?custtype, DateTime?effectivedate, string cTypetext = "", string statustext = "", string Location = "", int status = 1, int pageNo = 1, int pageSize = 0)
{
MainViewModel.SubscriptionViewModel customerViewModel = new MainViewModel.SubscriptionViewModel();
var suscriberList = suscription.getSuscriberList(customerId, custtype, effectivedate, pageNo, pageSize, Location, status);
var subscriptionExcelList = suscriberList.Select(x => new ExcelViewModel.SubscriptionExcelViewModel()
{
custno = x.CustNo,
SubsNo = x.SubsNo,
CustomerName = x.CustomerName,
LocationName = x.LocationName,
EffectiveDate = x.EffectiveDate,
LedgerName = x.LedgerName,
MonthlyAmount = x.MonthlyAmount,
Status = x.Status
}).ToList();
if (cTypetext == "--Select Event--")
{
cTypetext = "";
}
string[] columns = { "Customer No", "Subscription No.", "Customer Name", "LocationName", "Effective Date", "Ledger Name", "Monthly Amount", "Status" };
string[] parameterSearch = { "Location.:" + Location, "Effective Date:" + effectivedate, "Customer Type:" + cTypetext, "Status:" + statustext };
byte[] fileContent = ExcelExportHelper.ExportExcel(subscriptionExcelList, parameterSearch, null, "Subscription Report", columns);
return(File(fileContent, ExcelExportHelper.ExcelContentType, "Subscription Report.xlsx"));
}
public ActionResult CustomerInfoList(int[] listBox, string mode, string custType, int pageNo = 1, int pageSize = 5)
{
if (mode == "SubscriptionReport")
{
MainViewModel.SubscriptionViewModel customerViewModel = new MainViewModel.SubscriptionViewModel();
var suscriberList = customerService.SubscriberInfoList("", "", "", "", 1, 10);
customerViewModel.suscriberPagedList = new StaticPagedList <MainViewModel.SubscriptionViewModel>(suscriberList, 1, 10, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount);
//foreach (var item in customerList)
//{
// customerViewModel.customerViewModelList.Add(item);
//}
return(PartialView("~/Views/Suscription/_SubscriptionPopup.cshtml", customerViewModel));
}
else
{
MainViewModel.CustomerViewModel custInfoModel = new MainViewModel.CustomerViewModel();
var custtomerList = customerService.CustomerInfoList("", "", "", custType, pageNo, pageSize);
custInfoModel.customerPagedList = new StaticPagedList <MainViewModel.CustomerViewModel>(custtomerList, pageNo, pageSize, (custtomerList.Count == 0) ? 0 : custtomerList.FirstOrDefault().TotalCount);
return(PartialView(custInfoModel));
}
}
public ActionResult Create(MainViewModel.SubscriptionViewModel suscriptions)
{
try
{
returnMessage = suscription.Save(suscriptions);
return(Json(returnMessage, JsonRequestBehavior.AllowGet));
}
catch (DbEntityValidationException ex)
{
//returnMessage.Msg = "Not Saved" + ex.Message;
//return returnMessage;
foreach (var eve in ex.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw ex;
}
}
public ActionResult _MultipleBarcodeList(string name, string address, string printed, int pageNo = 1, int pageSize = 200)
{
MainViewModel.SubscriptionViewModel customerViewModel = new MainViewModel.SubscriptionViewModel();
var suscriberList = suscription.getSuscriberListForQRCode(name, address, printed, pageNo, pageSize);
customerViewModel.suscriberPagedList = new StaticPagedList <MainViewModel.SubscriptionViewModel>(suscriberList, pageNo, pageSize, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount);
return(PartialView(customerViewModel));
}
public MainViewModel.SubscriptionViewModel GetSelectedSubscription(int susid, string custType)
{
MainViewModel.SubscriptionViewModel customerInfoList = new MainViewModel.SubscriptionViewModel();
customerInfoList = uow.Repository <MainViewModel.SubscriptionViewModel>().SqlQuery(@"select * from[dbo].[fgetSubscriptionList]() where subsid={0} ", susid).SingleOrDefault();
return(customerInfoList);
}
public ActionResult MultipleQRCodeIndex(string name, string address, string printed, int pageNo = 1, int pageSize = 200)
{
MainViewModel.SubscriptionViewModel barcode = new MainViewModel.SubscriptionViewModel();
var suscriberList = suscription.getSuscriberListForQRCode(name, address, printed, pageNo, pageSize);
barcode.suscriberPagedList = new StaticPagedList <MainViewModel.SubscriptionViewModel>(suscriberList, pageNo, pageSize, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount);
return(View(barcode));
}
public ActionResult Create(int?sNo, int?customerid, string custname = "")
{
MainViewModel.SubscriptionViewModel suscriptionModel = new MainViewModel.SubscriptionViewModel();
if (sNo == null)
{
suscriptionModel.CustId = customerid;
suscriptionModel.CustomerName = custname;
}
else
{
suscriptionModel = suscription.getSingleSuscriptonList(sNo);
ViewBag.EffectiveDate = suscriptionModel.EffectiveDate.Value.Month.ToString() + "-" + suscriptionModel.EffectiveDate.Value.Day.ToString() + "-" + suscriptionModel.EffectiveDate.Value.Year.ToString();
var customerName = customerService.GetSelectedMultipleCustomer(Convert.ToInt32(suscriptionModel.CustId));
suscriptionModel.CustomerName = customerName.CustomerName;
}
return(PartialView(suscriptionModel));
}
public ActionResult _CustomerInfoList(string searchParam, string searchOption, string mode, string custType, int pageNo = 1, int pageSize = 5)
{
if (mode == "SubscriptionReport")
{
MainViewModel.SubscriptionViewModel customerViewModel = new MainViewModel.SubscriptionViewModel();
var suscriberList = customerService.SubscriberInfoList(searchParam, searchOption, mode, custType, pageNo, pageSize);
//if (searchOption != null && searchOption == "Customer Name")
//{
// suscriberList = suscriberList.Where(x => x.CustomerName.ToLower().Contains(searchParam.ToLower())).ToList();
//}
//if (searchOption != null && searchOption == "Subscription No")
//{
// suscriberList = suscriberList.Where(x => x.SubsNo == Convert.ToInt32(searchParam)).ToList();
//}
customerViewModel.suscriberPagedList = new StaticPagedList <MainViewModel.SubscriptionViewModel>(suscriberList, pageNo, pageSize, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount);
//foreach (var item in customerList)
//{
// customerViewModel.customerViewModelList.Add(item);
//}
return(PartialView("~/Views/Suscription/_SubscriptionPopupPartial.cshtml", customerViewModel));
}
else
{
MainViewModel.CustomerViewModel custInfoModel = new MainViewModel.CustomerViewModel();
List <MainViewModel.CustomerViewModel> custList = new List <MainViewModel.CustomerViewModel>();
var custtomerList = customerService.CustomerInfoList(searchParam, searchOption, mode, custType, pageNo, pageSize);
custInfoModel.customerPagedList = new StaticPagedList <MainViewModel.CustomerViewModel>(custtomerList, pageNo, pageSize, (custtomerList.Count == 0) ? 0 : custtomerList.FirstOrDefault().TotalCount);
//if (listBox != null)
//{
// foreach (var item in listBox)
// {
// MainViewModel.CustomerViewModel selectCustInfoModel = new MainViewModel.CustomerViewModel();
// selectCustInfoModel.CID = item;
// custList.Add(selectCustInfoModel);
// }
//}
//custInfoModel.SelectedCustInfoList = custList;
return(PartialView("_CustomerInfoList", custInfoModel));
}
}
public MainViewModel.SubscriptionViewModel getSingleSuscriptonList(int?sno)
{
var subsList = uow.Repository <Subscription>().FindBy(x => x.Subsid == sno);
MainViewModel.SubscriptionViewModel subsSingleList = subsList.Select(x => new MainViewModel.SubscriptionViewModel
{
Subsid = x.Subsid,
CustId = x.CustId,
LedgerId = x.LedgerId,
MonthlyAmount = x.MonthlyAmount,
LocationID = x.LocationID,
DharautiAmt = x.DharautiAmt,
RegistrationFee = x.RegistrationFee,
EffectiveDate = x.EffectiveDate,
Remarks = x.Remarks
}).SingleOrDefault();
return(subsSingleList);
}
public ActionResult _List(int?customerId, int pageNo = 1, int pageSize = 10)
{
try
{
MainViewModel.SubscriptionViewModel customerViewModel = new MainViewModel.SubscriptionViewModel();
var suscriberList = suscription.getSuscriberList(customerId, null, null, 1, 10, "", 1);
customerViewModel.suscriberPagedList = new StaticPagedList <MainViewModel.SubscriptionViewModel>(suscriberList, pageNo, pageSize, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount);
//foreach (var item in customerList)
//{
// customerViewModel.customerViewModelList.Add(item);
//}
return(PartialView(customerViewModel));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult _SuscriptionReportList(int?customerId, int?custtype, DateTime?effectivedate, string Location = "", int status = 1, int pageNo = 1, int pageSize = 10)
{
try
{
MainViewModel.SubscriptionViewModel customerViewModel = new MainViewModel.SubscriptionViewModel();
var suscriberList = suscription.getSuscriberList(customerId, custtype, effectivedate, pageNo, pageSize, Location, status);
customerViewModel.suscriberPagedList = new StaticPagedList <MainViewModel.SubscriptionViewModel>(suscriberList, pageNo, pageSize, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount);
//foreach (var item in customerList)
//{
// customerViewModel.customerViewModelList.Add(item);
//}
return(PartialView(customerViewModel));
}
catch (Exception ex)
{
throw ex;
}
}
public ReturnBaseMessageModel Save(MainViewModel.SubscriptionViewModel suscription)
{
try
{
var subsid = suscription.Subsid.GetType();
var CustId = suscription.CustId.GetType();
uow.ExecWithStoreProcedure("[dbo].[PcreateSubscription] @Subsid,@CustId,@EffectiveDate,@LedgerId,@MonthlyAmount,@LocationId,@Remarks,@PostedBy,@DharautiAmt,@RegistrationFee",
new SqlParameter("@Subsid", suscription.Subsid),
new SqlParameter("@CustId", suscription.CustId),
new SqlParameter("@EffectiveDate", suscription.EffectiveDate),
new SqlParameter("@LedgerId", suscription.LedgerId),
new SqlParameter("@MonthlyAmount", suscription.MonthlyAmount),
new SqlParameter("@LocationId", suscription.LocationID),
new SqlParameter("@Remarks", suscription.Remarks),
new SqlParameter("@PostedBy", Global.UserId),
new SqlParameter("@DharautiAmt", suscription.DharautiAmt),
new SqlParameter("@RegistrationFee", suscription.RegistrationFee)
);
if (suscription.Subsid == 0)
{
returnMessage.Msg = "Suscription Added Sucessfully";
}
else
{
returnMessage.Msg = "Suscription Edited Sucessfully";
}
returnMessage.Success = true;
return(returnMessage);
}
catch (Exception ex)
{
returnMessage.Msg = "Suscription Not Saved";
returnMessage.Success = false;
return(returnMessage);
throw ex;
}
}
public ActionResult SubscriberStatement()
{
try
{
MainViewModel.SubscriptionViewModel subscriptionViewModel = new MainViewModel.SubscriptionViewModel();
//var suscriberList = reportService.getSubscriberStatementList(subsid, FromDate, ToDate, 1, 10);
//subscriptionViewModel.subscriptionPagedList = new StaticPagedList<MainViewModel.SubscriptionReport>(suscriberList, 1, 10, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount);
//foreach (var item in customerList)
//{
// customerViewModel.customerViewModelList.Add(item);
//}
subscriptionViewModel.ModelFrom = "SubscriptionReport";
return(PartialView(subscriptionViewModel));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Index()
{
MainViewModel.SubscriptionViewModel collection = new MainViewModel.SubscriptionViewModel();
collection.ModelFrom = "Collection";
return(PartialView(collection));
}
// GET: Suscription
public ActionResult Index()
{
MainViewModel.SubscriptionViewModel suscriptionModel = new MainViewModel.SubscriptionViewModel();
suscriptionModel.ModelFrom = "Suscription";
return(PartialView(suscriptionModel));
}
