public ActionResult Register([Bind(Include = "UserId,UserName,UserPassword,Useremail")] UserLogin userLogin)
{
if (ModelState.IsValid)
{
db.UserLogins.Add(userLogin);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
return(View());
}
public ActionResult Create([Bind(Include = "ProductId,ProductName,Price,ProductImage,Description,Quantity,refSubCategoryId")] ProductMaster productMaster)
{
if (ModelState.IsValid)
{
db.ProductMasters.Add(productMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.refSubCategoryId = new SelectList(db.SubCategoryMasters, "SubCategoryId", "SubCategoryName", productMaster.refSubCategoryId);
return(View(productMaster));
}
public ActionResult Create([Bind(Include = "CartId,Qnt,Date,refUserId,refProductId")] CartMaster cartMaster)
{
if (ModelState.IsValid)
{
db.CartMasters.Add(cartMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.refProductId = new SelectList(db.ProductMasters, "ProductId", "ProductName", cartMaster.refProductId);
ViewBag.refUserId = new SelectList(db.UserMasters, "UserId", "UserName", cartMaster.refUserId);
return(View(cartMaster));
}
public void AddOrUpdate(ICompanyModel model)
{
try
{
using (var ctx = new DBProjectEntities())
{
var newObject = ctx.Firmy.Find(model.Id);
if (newObject == null)
{
newObject = Mapper.ModelMapper.Mapper.Map <Firmy>(model);
ctx.Firmy.Add(newObject);
}
else
{
newObject.nazwa_firmy = newObject.nazwa_firmy;
newObject.NIP = newObject.NIP;
newObject.nr_telefonu = newObject.nr_telefonu;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Logger.Log(ex.Message);
}
}
public void AddOrUpdate(IRepairModel model)
{
try
{
using (var ctx = new DBProjectEntities())
{
var newObject = ctx.Naprawy.Find(model.Id);
if (newObject == null)
{
newObject = Mapper.ModelMapper.Mapper.Map <Naprawy>(model);
ctx.Naprawy.Add(newObject);
}
else
{
newObject.data_rozpoczecia = model.data_rozpoczecia;
newObject.data_ukonczenia = model.data_ukonczenia;
newObject.data_zlecenia = model.data_zlecenia;
newObject.id_firmy = model.id_firmy;
newObject.id_usterki = model.id_usterki;
newObject.nr_telefonu = model.nr_telefonu;
newObject.stan = model.stan;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Logger.Log(ex.Message);
}
}
public void AddOrUpdate(IRentalModel model)
{
try
{
using (var ctx = new DBProjectEntities())
{
var newObject = ctx.Wynajmy.Find(model.Id);
if (newObject == null)
{
newObject = Mapper.ModelMapper.Mapper.Map <Wynajmy>(model);
ctx.Wynajmy.Add(newObject);
}
else
{
newObject.id_najemcy = model.id_najemcy;
newObject.id_mieszkania = model.id_mieszkania;
newObject.cena_miesieczna = model.cena_miesieczna;
newObject.data_rozpoczecia = model.data_rozpoczecia;
newObject.data_zakonczenia = model.data_zakonczenia;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Logger.Log(ex.Message);
}
}
public void AddOrUpdate(IFaultModel model)
{
try
{
using (var ctx = new DBProjectEntities())
{
var newObject = ctx.Usterki.Find(model.Id);
if (newObject == null)
{
newObject = Mapper.ModelMapper.Mapper.Map <Usterki>(model);
ctx.Usterki.Add(newObject);
}
else
{
newObject.id_mieszkania = model.id_mieszkania;
newObject.opis = model.opis;
newObject.stan = model.stan;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Logger.Log(ex.Message);
}
}
public void AddOrUpdate(IPaymentModel model)
{
try
{
using (var ctx = new DBProjectEntities())
{
var newObject = ctx.Platnosci.Find(model.Id);
if (newObject == null)
{
newObject = Mapper.ModelMapper.Mapper.Map <Platnosci>(model);
ctx.Platnosci.Add(newObject);
}
else
{
newObject.id_wynajmu = model.id_wynajmu;
newObject.cena = model.cena;
newObject.tytul = model.tytul;
newObject.data_platnosci = model.data_platnosci;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Logger.Log(ex.Message);
}
}
public void AddOrEditPayment(PaymentModel newPayment)
{
try
{
using (var ctx = new DBProjectEntities())
{
var payment = ctx.Platnosci.Find(newPayment.id_platnosci);
if (payment == null)
{
payment = ModelMapper.Mapper.Map <Platnosci>(newPayment);
ctx.Platnosci.Add(payment);
}
else
{
payment.id_wynajmu = newPayment.id_wynajmu;
payment.id_platnosci = newPayment.id_platnosci;
payment.cena = newPayment.cena;
payment.data_platnosci = newPayment.data_platnosci;
payment.tytul = newPayment.tytul;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public bool Remove(int id)
{
try
{
using (var ctx = new DBProjectEntities())
{
var queryResult = ctx.Dozorcy.Where(x => x.id == id).FirstOrDefault();
if (queryResult is null)
{
return(false);
}
else
{
ctx.Dozorcy.Remove(queryResult);
ctx.SaveChanges();
return(true);
}
}
}
catch (Exception ex)
{
Logger.Log(ex.Message);
return(false);
}
}
//REPAIRS BILLS
public bool AddOrEditRepairBill(RepairBillModel newRepairBill)
{
if (newRepairBill.id_naprawy == null)
{
return(false); //This repair bill is not connected to any repair - kinda useless.
}
try
{
using (var ctx = new DBProjectEntities())
{
var repairBill = ctx.FakturyNapraw.Find(newRepairBill.id_faktury);
if (repairBill == null) //DB did not find any record like provided one. Add it.
{
repairBill = ModelMapper.Mapper.Map <FakturyNapraw>(newRepairBill);
ctx.FakturyNapraw.Add(repairBill);
}
else//There's a record that contains the residence already - modify it.
{
repairBill.cena = newRepairBill.cena;
repairBill.data_platnosci = newRepairBill.data_platnosci;
repairBill.id_naprawy = newRepairBill.id_naprawy;
repairBill.numer_faktury = newRepairBill.numer_faktury;
repairBill.id_faktury = newRepairBill.id_faktury;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
return(true);
}
public void AddOrEditResident(ResidentModel newResident)
{
try
{
using (var ctx = new DBProjectEntities())
{
var resident = ctx.Najemcy.Find(newResident.id_najemcy);
if (resident == null)
{
resident = ModelMapper.Mapper.Map <Najemcy>(newResident);
ctx.Najemcy.Add(resident);
}
else
{
resident.imie = newResident.imie;
resident.nazwisko = newResident.nazwisko;
resident.nr_telefonu = newResident.nr_telefonu;
resident.PESEL = newResident.PESEL;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void AddOrEditResidence(ResidenceModel newResidence)
{
try
{
using (var ctx = new DBProjectEntities())
{
var residence = ctx.Mieszkania.FirstOrDefault(x => x.id_budynku == newResidence.id_budynku && x.id_mieszkania == newResidence.id_mieszkania);
if (residence == null) //DB did not find any record like provided one. Add it.
{
residence = ModelMapper.Mapper.Map <Mieszkania>(newResidence);
ctx.Mieszkania.Add(residence);
}
else//There's a record that contains the residence already - modify it.
{
residence.numer = newResidence.numer;
residence.metraz = newResidence.metraz;
residence.opis = newResidence.opis;
//ctx.Entry(residence).State = EntityState.Modified;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void AddOrUpdate(ISupervisorModel model)
{
try
{
using (var ctx = new DBProjectEntities())
{
var newObject = ctx.Dozorcy.Find(model.Id);
if (newObject == null)
{
newObject = Mapper.ModelMapper.Mapper.Map <Dozorcy>(model);
ctx.Dozorcy.Add(newObject);
}
else
{
newObject.Imie = model.Imie;
newObject.Nazwisko = model.Nazwisko;
newObject.PESEL = model.PESEL;
newObject.nr_telefonu = model.nr_telefonu;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Logger.Log(ex.Message);
}
}
public void AddOrEditCompany(CompanyModel newCompany)
{
try
{
using (var ctx = new DBProjectEntities())
{
var company = ctx.Firmy.Find(newCompany.id_firmy);
if (company == null)
{
company = ModelMapper.Mapper.Map <Firmy>(newCompany);
ctx.Firmy.Add(company);
}
else
{
company.NIP = newCompany.NIP;
company.id_firmy = newCompany.id_firmy;
company.nr_telefonu = newCompany.nr_telefonu;
company.nazwa_firmy = newCompany.nazwa_firmy;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void AddOrUpdate(IFlatModel model)
{
try
{
using (var ctx = new DBProjectEntities())
{
var newObject = ctx.Mieszkania.Find(model.Id);
if (newObject == null)
{
newObject = Mapper.ModelMapper.Mapper.Map <Mieszkania>(model);
ctx.Mieszkania.Add(newObject);
}
else
{
newObject.id_budynku = model.id_budynku;
newObject.metraz = model.metraz;
newObject.numer = model.numer;
newObject.opis = model.opis;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Logger.Log(ex.Message);
}
}
public void AddOrUpdate(ISupervisingModel model)
{
try
{
using (var ctx = new DBProjectEntities())
{
var newObject = ctx.Dozorowania.Where(x => x.id_budynku == model.id_budynku && x.id_dozorcy == model.id_dozorcy).FirstOrDefault();
if (newObject == null)
{
newObject = Mapper.ModelMapper.Mapper.Map <Dozorowania>(model);
ctx.Dozorowania.Add(newObject);
}
else
{
newObject.data_rozpoczecia = model.data_rozpoczecia;
newObject.data_zakonczenia = model.data_zakonczenia;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Logger.Log(ex.Message);
}
}
//PAYMENTS BILLS
public bool AddOrEditPaymentBill(PaymentBillModel newPaymentBill)
{
if (newPaymentBill.id_wynajem == null)
{
return(false); //This payment is not connected to any rental - kinda useless.
}
try
{
using (var ctx = new DBProjectEntities())
{
var payment = ctx.FakturyWynajem.Find(newPaymentBill.id_wynajem);
if (payment == null) //DB did not find any record like provided one. Add it.
{
payment = ModelMapper.Mapper.Map <FakturyWynajem>(newPaymentBill);
ctx.FakturyWynajem.Add(payment);
}
else//There's a record that contains the residence already - modify it.
{
payment.cena = newPaymentBill.cena;
payment.data_platnosci = newPaymentBill.data_platnosci;
payment.id_wynajem = newPaymentBill.id_wynajem;
payment.numer_faktury = newPaymentBill.numer_faktury;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
return(true);
}
public void AddOrUpdate(IBuildingModel model)
{
try
{
using (var ctx = new DBProjectEntities())
{
var newObject = ctx.Budynki.Find(model.Id);
if (newObject == null)
{
newObject = Mapper.ModelMapper.Mapper.Map <Budynki>(model);
ctx.Budynki.Add(newObject);
}
else
{
newObject.adres_budynku = model.adres_budynku;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Logger.Log(ex.Message);
}
}
public void AddOrUpdate(IRentalBillModel model)
{
try
{
using (var ctx = new DBProjectEntities())
{
var newObject = ctx.FakturyWynajem.Find(model.Id);
if (newObject == null)
{
newObject = Mapper.ModelMapper.Mapper.Map <FakturyWynajem>(model);
ctx.FakturyWynajem.Add(newObject);
}
else
{
newObject.id_wynajem = model.id_wynajem;
newObject.numer_faktury = model.numer_faktury;
newObject.data_platnosci = model.data_platnosci;
newObject.cena = model.cena;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Logger.Log(ex.Message);
}
}
public void AddOrEditPaymentBill(PaymentBillModel newPaymentBill)
{
try
{
using (var ctx = new DBProjectEntities())
{
var paymentBill = ctx.FakturyWynajem.Find(newPaymentBill.id_faktury);
if (paymentBill == null)
{
paymentBill = ModelMapper.Mapper.Map <FakturyWynajem>(newPaymentBill);
ctx.FakturyWynajem.Add(paymentBill);
}
else
{
paymentBill.id_wynajem = newPaymentBill.id_wynajem;
paymentBill.id_faktury = newPaymentBill.id_faktury;
paymentBill.cena = newPaymentBill.cena;
paymentBill.data_platnosci = newPaymentBill.data_platnosci;
paymentBill.numer_faktury = newPaymentBill.numer_faktury;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public ActionResult Create([Bind(Include = "ProductId,ProductName,Price,ProductImage,Description,Quantity,refSubCategoryId")] ProductMaster productMaster, HttpPostedFileBase ProductImage)
{
try
{
string dirPath = Server.MapPath("~/Content/Admin/Images/");
if (!Directory.Exists(dirPath))
{
Directory.CreateDirectory(dirPath);
}
string filename = "Product_" + Guid.NewGuid().ToString().Replace('-', '_') + "." + ProductImage.FileName.Split('.')[1];
string filepath = dirPath + "\\" + filename;
ProductImage.SaveAs(filepath);
ViewBag.message = "Image Uploaded!";
productMaster.ProductImage = filename;
if (ModelState.IsValid)
{
db.ProductMasters.Add(productMaster);
db.SaveChanges();
TempData["msg"] = "Product Details Saved!!";
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
TempData["err"] = ex.Message;
ViewBag.error = ex.Message;
}
ViewBag.CategoryId = new SelectList(db.CategoryMasters, "CategoryId", "CategoryName");
ViewBag.refSubCategoryId = new List <SelectListItem>()
{
new SelectListItem()
{
Text = "", Value = "Select Sub Category"
}
};
//ViewBag.refSubCategoryId = new SelectList(db.SubCategoryMasters, "SubCategoryId", "SubCategoryName", productMaster.refSubCategoryId);
return(View(productMaster));
}
public ActionResult Create([Bind(Include = "CategoryId,CategoryName")] CategoryMaster categoryMaster)
{
if (ModelState.IsValid)
{
try
{
db.CategoryMasters.Add(categoryMaster);
db.SaveChanges();
TempData["msg"] = "Category Details Saved!!";
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
TempData["err"] = ex.Message;
}
}
return(View(categoryMaster));
}
public ActionResult Create([Bind(Include = "SubCategoryId,SubCategoryName,refCategoryId")] SubCategoryMaster subCategoryMaster)
{
if (ModelState.IsValid)
{
try
{
db.SubCategoryMasters.Add(subCategoryMaster);
db.SaveChanges();
TempData["msg"] = "SubCategory Details Saved!!";
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
TempData["err"] = ex.Message;
}
}
ViewBag.refCategoryId = new SelectList(db.CategoryMasters, "CategoryId", "CategoryName", subCategoryMaster.refCategoryId);
return(View(subCategoryMaster));
}
public void RemoveResident(int residentId)
{
try
{
using (var ctx = new DBProjectEntities())
{
var result = ctx.Najemcy.Find(residentId);
if (result != null)
{
ctx.Najemcy.Remove(result);
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void RemoveCompany(int companyId)
{
try
{
using (var ctx = new DBProjectEntities())
{
var result = ctx.Firmy.Find(companyId);
if (result != null)
{
ctx.Firmy.Remove(result);
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception("An error occured while processing your request.");
}
}
public void RemovePaymentBill(int paymentBillId)
{
try
{
using (var ctx = new DBProjectEntities())
{
var result = ctx.FakturyWynajem.Find(paymentBillId);
if (result != null)
{
ctx.FakturyWynajem.Remove(result);
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception("Error - could not fulfill the request.");
}
}
public void RemoveBuilding(int buildingId)
{
try
{
using (var ctx = new DBProjectEntities())
{
var result = ctx.Budynki.Find(buildingId);
if (result != null)
{
ctx.Budynki.Remove(result);
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception("Cannot remove building - remove all residences assigned to it first.");
}
}
public void RemoveResidence(int buildingId, int residenceId)
{
try
{
using (var ctx = new DBProjectEntities())
{
var result = ctx.Mieszkania.FirstOrDefault(x => x.id_budynku == buildingId && x.id_mieszkania == residenceId);
if (result != null)
{
ctx.Mieszkania.Remove(result);
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception("Cannot remove residence - remove all faults and rentals connected with it first.");
}
}
public void RemoveRepair(int repairId)
{
try
{
using (var ctx = new DBProjectEntities())
{
var result = ctx.Naprawy.Find(repairId);
if (result != null)
{
ctx.Naprawy.Remove(result);
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception("Cannot delete provided repair - remove connected bills first.");
}
}
