public static void Insertinvoiceperiods(Createinvoiceperiods item) { if (item != null) { item.Uid = Guid.NewGuid(); item.num = Context.customer_services.Where(x => x.status == customer_services.Status.ready).Count(); item.status = Createinvoiceperiods.Statusinvoiceperiods.Wait; Context.Createinvoiceperiods.Add(item); Context.SaveChanges(); foreach (var i in Context.customer_services.Where(x => x.status == customer_services.Status.ready)) { AssetDbContext add = new AssetDbContext(); var data = new waterwork.Models.Water_usage() { Uid = Guid.NewGuid(), invoiceperiods_id = item.Uid, customer_services_id = i.Uid, water_Unit = 0 }; add.Water_usage.Add(data); add.SaveChanges(); } ; } }
public static IEnumerable GetWater_usage_id(Guid id) { AssetDbContext Context = new AssetDbContext(); var item = Context.Water_usage.Where(x => x.invoiceperiods_id == id && x.water_Unit == 0).ToList(); return(item.ToList()); }
public ActionResult Information() { AssetDbContext Context = new AssetDbContext(); var cus = customer_services.Getcustomer_services(); return(View(cus)); }
public static int GetWater_usage_inid(Guid id) { AssetDbContext Context = new AssetDbContext(); int item = Context.Water_usage.Where(x => x.invoiceperiods_id == id && x.water_Unit == 0).Count(); return(item); }
public ActionResult DocumentViewerPartial() { AssetDbContext Context = new AssetDbContext(); string id = Session["Uid"].ToString(); var pro = Context.customer_services.Where(x => x.Uid.ToString() == id).ToList(); return(PartialView("DocumentViewerPartial", pro)); }
public IssueController(AssetDbContext db) { _db = db; AssetVM = new AssetViewModel() { AssetDetails = _db.AssetDetails.ToList(), AssetIssueDetails = new AssetIssueDetails() }; }
public ActionResult AddServicesquantity( ) { AssetDbContext Context = new AssetDbContext(); string id = Url.RequestContext.RouteData.Values["id"].ToString(); customer_services[] cus = Context.customer_services.Where(x => x.customer_id.ToString() == id).ToArray(); return(PartialView("AddServicesquantity", cus.ToList())); }
public AssetEntryUnitOfWork(AssetDbContext context) { _context = context; AssetEntry = new AssetEntryRepository(_context); Finance = new FinanceRepository(_context); ServiceOrRepairing = new ServiceOrRepairingRepository(_context); Note = new NoteRepository(_context); Attchment = new AttachmentRepository(_context); }
public ActionResult ExportDocumentViewer() { AssetDbContext Context = new AssetDbContext(); string id = Session["Uid"].ToString(); var pro = Context.customer_services.Where(x => x.Uid.ToString() == id).ToList(); XtraReport1 report = new XtraReport1(); report.DataSource = pro; return(ReportViewerExtension.ExportTo(report)); }
public static void Insertcustomer_services(customer_services item) { AssetDbContext Context = new AssetDbContext(); if (item != null) { item.Uid = Guid.NewGuid(); Context.customer_services.Add(item); Context.SaveChanges(); } }
public AssetSetupUnitOfWork(AssetDbContext context) { _context = context; AssetType = new AssetTypeRepository(_context); AssetGroup = new AssetGroupRepository(_context); AssetManufacurer = new AssetManufactureRepository(_context); AssetModel = new AssetModelRepository(_context); }
public ActionResult Misterupdate(MVCxGridViewBatchUpdateValues <customer_services, int> updateValues) { AssetDbContext context = new AssetDbContext(); foreach (var Item in updateValues.Update) { var data = context.customer_services.Find(Item.Uid); data.status = customer_services.Status.ready; data.meter_id = Item.meter_id; data.meter_First_unit = Item.meter_First_unit; context.SaveChanges(); } return(PartialView("MisterDataEditPartialView", waterwork.DAL.DALcustomer_services.Getcustomer_services_Wait())); }
public ActionResult Water_usageAdd(Water_usage item) { AssetDbContext Context = new AssetDbContext(); var data = Context.Water_usage.Find(item.customer_services_id); data.invoiceperiods_id = new Guid(Session["invoiceperiods_id"].ToString()); data.water_Unit = item.water_Unit; Context.SaveChanges(); Session["invoiceperiods_id"] = data.invoiceperiods_id; ViewBag.time = Session["invoiceperiods_id"]; if (DAL.DALWater_usage.GetWater_usage_inid(data.invoiceperiods_id) == 0) { var i = Context.Createinvoiceperiods.Find(data.invoiceperiods_id); i.status = Statusinvoiceperiods.ready; Context.SaveChanges(); DALbill_Water.bill_Water_Add(data.invoiceperiods_id); } return(View(DAL.DALWater_usage.GetWater_usage())); }
public static void bill_Water_Add(Guid id) { AssetDbContext Context = new AssetDbContext(); var Water_use = Context.Water_usage.Where(x => x.invoiceperiods_id == id).ToList(); foreach (var i in Water_use) { var data = new bill_Water_usage { Uid = Guid.NewGuid(), Water_usage_id = i.Uid, water_usagefirst = 0, water_usageafter = i.water_Unit, unit = 0 - i.water_Unit, service_charge = 15, Minimum_rate = 35, price = (0 - i.water_Unit) * 5, status = bill_Water_usage.Statusbill.Wait }; Context.bill_Water_usage.Add(data); Context.SaveChanges(); } }
public AssetLocationUnitOfWork(AssetDbContext context) { _context = context; AssetLocation = new AssetLocationRepository(_context); }
public AssetGroupUnitOfWork(AssetDbContext context) { _context = context; AssetGroup = new AssetGroupRepository(_context); }
public HrUnitOfWork(AssetDbContext context) { _context = context; Employee = new EmployeeRepository(_context); }
public static IEnumerable Getprovince() { AssetDbContext Context = new AssetDbContext(); return(Context.province.ToList()); }
public static IEnumerable Getcustomer_services() { AssetDbContext Context = new AssetDbContext(); return(Context.customer_services.ToList()); }
public static IEnumerable GetUserProfile(string id) { AssetDbContext Context = new AssetDbContext(); return(Context.customers.Where(x => x.Uid.ToString() == id).ToList()); }
public static IEnumerable GetSearchUserProfile() { AssetDbContext Context = new AssetDbContext(); return(Context.customers.ToList()); }
public NoteUnitOfWork(AssetDbContext context) { _context = context; Note = new NoteRepository(_context); }
public static IEnumerable Getplace(int id) { AssetDbContext Context = new AssetDbContext(); return(Context.place.Where(x => x.amphur_id == id).ToList()); }
public GeneralCategoryRepository() { _context = new AssetDbContext(); }
public OrganizationUnitOfWork(AssetDbContext context) { _context = context; Orgnation = new OrganizationRepository(_context); Branch = new BranchRepository(_context); }
public static IEnumerable Getamphur(int id) { AssetDbContext Context = new AssetDbContext(); return(Context.amphur.Where(x => x.province_id == id).ToList()); }
public BranchRepository(AssetDbContext context) : base(context) { }
public Services(AssetDbContext db) { _Db = db; }
public DesignationUnitOfWork(AssetDbContext context) { _context = context; Designation = new DesignationRepository(_context); }
public AssetRepository(AssetDbContext context) { _context = context; }