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