public static int CreateLandlord(Landlord entity)
{
try
{
using (var ctx = new PosContext())
{
var found = ctx.Landlord.FirstOrDefault(a => a.Email == entity.Email);
if (found == null)
{
var model = ctx.Landlord.Add(entity);
ctx.SaveChanges();
AgencyContext.AddNewLandlord(model);
return model.Id;
}
else
{
//TODO If landlord is found he might have an account, maybe with another agency
/*TODO HE May also be created without being invited to the site so he has no login so need to check
* TODO whether or not the agency want to link him to one of the entities within their database
*
*/
}
return -1;
}
}
catch (Exception ex)
{
return -1;
}
}
public static int CreateLog(Log log)
{
try
{
using (var ctx = new PosContext())
{
var email = HttpContext.Current.User.Identity.Name;
log.CreatedByEmail = email;
var found = ctx.Log.FirstOrDefault(a => a.Id == log.Id);
if (found == null)
{
log.CreatedDateTime = DateTime.Now;
var model = ctx.Log.Add(log);
ctx.SaveChanges();
return model.Id;
}
return -1;
}
}
catch (Exception ex)
{
return -1;
}
}
public void WhenAddingAUTable_TablesTableCountIsIncrementedByOne()
{
int beforeCount = 0;
int afterCount = 0;
using (var db = new PosContext())
{
beforeCount = db.Allergens.Count();
allergenCRUD.Create("testName");
afterCount = db.Allergens.Count();
}
Assert.AreEqual(beforeCount + 1, afterCount);
}
public static List<Property> GetAgencyProperties(int? agencyId)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.Property.Where(l => l.AgencyId == agencyId).Include(l => l.Agency).Include(l => l.Landlord).Include(l => l.Rooms).ToList();
return (model);
}
}
catch (Exception ex)
{
return null;
}
}
public static List<LogArchive> GetLogArchive(int? id)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.LogArchive.Where(l => l.Log.Id == id).ToList();
return (model);
}
}
catch (Exception ex)
{
return null;
}
}
public static Log GetLog(int logId)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.Log.Include(l => l.Property).Include(l => l.AssignedContractor).FirstOrDefault(l => l.Id == logId);
return (model);
}
}
catch (Exception ex)
{
return null;
}
}
public void WhenDeletingATable_TablesTableCountIsDecrementedByOne()
{
int beforeCount = 0;
int afterCount = 0;
using (var db = new PosContext())
{
db.Allergens.Add(TestAllergen);
db.SaveChanges();
allergenCRUD.selectedAllergen = TestAllergen;
beforeCount = db.Allergens.Count();
allergenCRUD.Remove(TestAllergen.AllergenID);
afterCount = db.Allergens.Count();
}
Assert.AreEqual(beforeCount - 1, afterCount);
}
public void WhenDeletingATable_TablesTableCountIsDecrementedByOne()
{
int beforeCount = 0;
int afterCount = 0;
using (var db = new PosContext())
{
db.Tables.Add(TestTable);
db.SaveChanges();
tableCRUD.selectedTable = TestTable;
beforeCount = db.Tables.Count();
tableCRUD.Delete(TestTable.TableName);
afterCount = db.Tables.Count();
}
Assert.AreEqual(beforeCount - 1, afterCount);
}
public void Remove(int orderID)
{
using (var db = new PosContext())
{
db.Orders.Remove(db.Orders.Find(orderID));
db.SaveChanges();
}
for (int i = 0; i < currentOrders.Count; i++)
{
if (currentOrders[i].OrderID == orderID)
{
currentOrders.RemoveAt(i);
}
}
}
public static int GetAgentsAgency(string agentsEmail)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.Agency.FirstOrDefault(l => l.AgencyEmail == agentsEmail);
return model.Id;
}
}
catch (Exception ex)
{
return -1;
}
}
public void WhenDeletingATable_TablesTableCountIsDecrementedByOne()
{
int beforeCount = 0;
int afterCount = 0;
using (var db = new PosContext())
{
db.Products.Add(TestProduct);
db.SaveChanges();
productCrud.selectedProduct = TestProduct;
beforeCount = db.Products.Count();
productCrud.Remove(TestProduct.ProductName);
afterCount = db.Products.Count();
}
Assert.AreEqual(beforeCount - 1, afterCount);
}
public void WhenDeletingATable_TablesTableCountIsDecrementedByOne()
{
int beforeCount = 0;
int afterCount = 0;
using (var db = new PosContext())
{
db.ProductCategories.Add(TestProductCategory);
db.SaveChanges();
productCategoryCRUD.selectedProductCategory = TestProductCategory;
beforeCount = db.ProductCategories.Count();
productCategoryCRUD.Delete(TestProductCategory.ProductCategoryName);
afterCount = db.ProductCategories.Count();
}
Assert.AreEqual(beforeCount - 1, afterCount);
}
public void Create(string tableName, string tableSite, int userID = 1, int tableStatusID = 1, int tableSeets = 4)
{
using (var db = new PosContext())
{
db.Tables.Add(new Table
{
TableName = tableName,
TableSeats = tableSeets,
TableStatusID = 1,
UserID = userID,
TableSite = tableSite
});
db.SaveChanges();
}
}
public static Landlord GetLandlordByEmail(string email)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.Landlord.FirstOrDefault(l => l.Email == email);
return model;
}
}
catch (Exception ex)
{
return null;
}
}
public void Create(string productName, double productPrice, string productDescription, int productQuantity, int categoryID, int allergentID)
{
using (var db = new PosContext())
{
db.Products.Add(new Product
{
ProductCategoryID = categoryID,
ProductDescription = productDescription,
ProductName = productName,
ProductPrice = productPrice,
ProductQuantity = productQuantity,
AllergenID = allergentID
});
db.SaveChanges();
}
}
public static Landlord GetLandlordById(int id)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.Landlord.FirstOrDefault(l => l.Id == id);
return model;
}
}
catch (Exception ex)
{
return null;
}
}
public static Agency GetAgency(string currentEmail)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.Agency.FirstOrDefault(l => l.AgencyEmail == currentEmail);
return (model);
}
}
catch (Exception ex)
{
return null;
}
}
public void WhenDeletingAUser_UsersTableCountIsDecrementedByOne()
{
int beforeCount = 0;
int afterCount = 0;
using (var db = new PosContext())
{
db.Users.Add(TestUser);
db.SaveChanges();
userCRUD.selectedUser = TestUser;
beforeCount = db.Users.Count();
userCRUD.Delete(TestUser.UserID);
afterCount = db.Users.Count();
}
Assert.AreEqual(beforeCount - 1, afterCount);
}
public static Contractor GetContractorByEmail(string email)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.Contractor.FirstOrDefault(l => l.Email == email);
return model;
}
}
catch (Exception ex)
{
return null;
}
}
//Create dan Edit
public static bool Update(SupplierViewModel model)
{
bool result = true;
try
{
using (var db = new PosContext())
{
if (model.Id == 0)
{
Supplier supplier = new Supplier();
supplier.Id = model.Id;
supplier.Nama = model.Nama;
supplier.Alamat = model.Alamat;
supplier.NoTelp = model.NoTelp;
supplier.IsActivated = model.IsActivated;
supplier.CreatedBy = "Arief";
supplier.CreatedDate = DateTime.Now;
db.Mst_Suppliers.Add(supplier);
db.SaveChanges();
}
else
{
Supplier supplier = db.Mst_Suppliers.Where(d => d.Id == model.Id).FirstOrDefault();
if (supplier != null)
{
supplier.Nama = model.Nama;
supplier.Alamat = model.Alamat;
supplier.NoTelp = model.NoTelp;
supplier.IsActivated = model.IsActivated;
supplier.ModifiedBy = "Arief";
supplier.ModifiedDate = DateTime.Now;
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
result = false;
Message = ex.Message;
}
return(result);
}
public static List<File> GetPropertyImages(int? id)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.File.Where(f => f.PropertyId == id).ToList();
return model;
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return null;
}
}
public static List <TokoViewModel> GetAll()
{
List <TokoViewModel> result = new List <TokoViewModel>();
using (var db = new PosContext())
{
result = (from tk in db.Mst_Tokos
select new TokoViewModel
{
Id = tk.Id,
Nama = tk.Nama,
Alamat = tk.Alamat,
NoTelp = tk.NoTelp
}).ToList();
}
return(result);
}
public ActionResult Delete(int id)
{
var CustomerId = new SqlParameter("CustomerId", SqlDbType.Int);
CustomerId.Value = id;
using (PosContext db = new PosContext())
{
/* By using Entity Framework
* Customer cust = db.Customers.Where(x => x.CustomerId == id).FirstOrDefault<Customer>();
* db.Customers.Remove(cust);*/
//By Using stored Procedure
db.Database.ExecuteSqlCommand("exec Customer_Delete @CustomerId", CustomerId);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public static File GetFile(int? id)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.File.FirstOrDefault(t => t.Id == id);
return model;
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return null;
}
}
public void Setup()
{
using (var db = new PosContext())
{
productCategoryID = db.ProductCategories.Where(pc => pc.ProductCategoryName == "Test").Select(pc => pc.ProductCategoryID).FirstOrDefault();
allergentID = db.Allergens.Where(a => a.AllergenName == "Test").Select(a => a.AllergenID).FirstOrDefault();
}
TestProduct = new Product
{
AllergenID = allergentID,
ProductCategoryID = productCategoryID,
ProductDescription = "TestDescription",
ProductName = "TestName",
ProductPrice = 2.5,
ProductQuantity = 3
};
}
public static int CreateFile(File model)
{
try
{
using (var ctx = new PosContext())
{
ctx.File.Add(model);
ctx.SaveChanges();
return model.Id;
}
}
catch (Exception ex)
{
return -1;
}
}
public ActionResult AddorEdit(Customer cust)//we have to pass instance of object in defined stages of enity that's we have created instance
{
var CustomerId = new SqlParameter("CustomerId", SqlDbType.Int);
CustomerId.Value = cust.CustomerId;
var CustomerName = new SqlParameter("CustomerName", SqlDbType.NVarChar);
CustomerName.Value = cust.CustomerName;
var CustomerAddress = new SqlParameter("CustomerAddress", SqlDbType.NVarChar);
CustomerAddress.Value = cust.CustomerAddress;
var CustomerGender = new SqlParameter("Gender", SqlDbType.NVarChar);
CustomerGender.Value = cust.Gender;
using (PosContext db = new PosContext())
{
if (cust.CustomerId == 0 && ModelState.IsValid)
{
/*By using Entity Framework
* db.Customers.Add(cust);*/
//By using Stored Procedure
db.Database.ExecuteSqlCommand("exec Customer_Insert @CustomerName,@CustomerAddress,@Gender", CustomerName, CustomerAddress, CustomerGender);
db.SaveChanges();
return(Json(new { success = true, message = "saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else if (cust.CustomerId != 0 && ModelState.IsValid)
{
/*By using Entity framework
* db.Entry(cust).State = EntityState.Modified;*/
//By using Stored Procedure
db.Database.ExecuteSqlCommand("exec Customer_Update @CustomerId,@CustomerName,@CustomerAddress,@Gender", CustomerId, CustomerName, CustomerAddress, CustomerGender);
db.SaveChanges();
return(Json(new { success = true, message = "saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else if (!ModelState.IsValid)
{
ModelState.AddModelError("CustomerName", "Name is Required");
return(View());
}
else
{
return(View(cust));
}
}
}
public static ReturnValueViewModel SaveSelling(HeaderDetailPenjualanViewModel model)
{
ReturnValueViewModel result = new ReturnValueViewModel();
result.Success = true;
result.Referensi = GetNewReference();
try
{
using (var db = new PosContext())
{
HeaderPenjualan sh = new HeaderPenjualan();
sh.Id = 1;
sh.IdPembeli = model.IdPembeli;
sh.Referensi = result.Referensi;
sh.TanggalPenjualan = DateTime.Now;
sh.CreatedDate = DateTime.Now;
sh.CreatedBy = "Arief";
db.Trans_HeaderPenjualans.Add(sh);
foreach (var item in model.Details)
{
DetailPenjualan sd = new DetailPenjualan();
sd.IdHeaderPenjualan = sh.Id;
sd.IdBarang = item.IdBarang;
sd.HargaPenjualan = item.HargaPenjualan;
sd.JumlahBarang = item.JumlahBarang;
sd.Total = item.HargaPenjualan * item.JumlahBarang; //item.Amount;
sd.CreatedBy = "Arief";
sd.CreatedDate = DateTime.Now;
db.Trans_DetailPenjualans.Add(sd);
}
db.SaveChanges();
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.InnerException.ToString();
}
return(result);
}
public static List <SupplierViewModel> GetAll()
{
List <SupplierViewModel> result = new List <SupplierViewModel>();
using (var db = new PosContext())
{
result = (from sup in db.Mst_Suppliers
select new SupplierViewModel
{
Id = sup.Id,
Nama = sup.Nama,
Alamat = sup.Alamat,
NoTelp = sup.NoTelp,
IsActivated = sup.IsActivated
}).ToList();
}
return(result);
}
public static List<Log> GetPropertyLogs(int? propertyId)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.Log.Where(l => l.PropertyId == propertyId).
Include(l => l.Property).
Include(l => l.AssignedContractor).ToList();
return (model);
}
}
catch (Exception ex)
{
return null;
}
}
public ActionResult AddorEdit_Product(Product prod)//we have to pass instance of object in defined stages of enity that's we have created instance
{
using (PosContext db = new PosContext())
{
if (prod.ProductId == 0)
{
db.Products.Add(prod);
db.SaveChanges();
return(Json(new { success = true, message = "saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(prod).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "saved Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
//Create Method For Users: It Creates new Users and adds them to the User Table in the Database.
public void Create(string userRoleName, string userName, string userPassword, DateTime startDate)
{
using (var db = new PosContext())
{
int userRoleID = db.UserRoles.Where(u => u.UserRoleName == userRoleName).Select(x => x.UserRoleID).FirstOrDefault();
User newUser = new User
{
UserName = userName,
UserPassword = userPassword,
IsActive = true,
StartDate = startDate,
UserPoints = "0",
UserRoleID = userRoleID
};
db.Users.Add(newUser);
db.SaveChanges();
}
}
public void TestMethod1()
{
using (var db = new PosContext())
{
var barangs = db.Mst_Barangs.ToList();
if (db.Mst_Barangs.Any())
{
foreach (var barang in barangs)
{
Trace.WriteLine(string.Format("id:{0},Deskripsi:{1}", barang.Id, barang.Deskripsi));
}
}
else
{
Trace.WriteLine("Data tidak tersedia");
}
}
}
public static TokoViewModel GetById(int id)
{
TokoViewModel result = new TokoViewModel();
using (var db = new PosContext())
{
result = (from tk in db.Mst_Tokos
where tk.Id == id
select new TokoViewModel
{
Id = tk.Id,
Nama = tk.Nama,
Alamat = tk.Alamat,
NoTelp = tk.NoTelp
}).FirstOrDefault();
}
return(result);
}
public override string VisitPos(PosContext context)
{
if (context.NOUN() != null)
{
return(Generator.Noun);
}
if (context.VERB() != null)
{
return(Generator.Verb);
}
if (context.ADJECTIVE() != null)
{
return(Generator.Adjective);
}
return(context.TEXT() != null
? Text(context.TEXT())
: "*gibberish*");
}
public static SupplierViewModel GetById(int id)
{
SupplierViewModel result = new SupplierViewModel();
using (var db = new PosContext())
{
result = (from sup in db.Mst_Suppliers
where sup.Id == id
select new SupplierViewModel
{
Id = sup.Id,
Nama = sup.Nama,
Alamat = sup.Alamat,
NoTelp = sup.NoTelp,
IsActivated = sup.IsActivated
}).FirstOrDefault();
}
return(result);
}
public static bool Update(TokoViewModel model)
{
bool result = true;
try
{
using (var db = new PosContext())
{
if (model.Id == 0)
{
Toko toko = new Toko();
toko.Id = model.Id;
toko.Nama = model.Nama;
toko.Alamat = model.Alamat;
toko.NoTelp = model.NoTelp;
toko.CreatedBy = "Rio";
toko.CreatedDate = DateTime.Now;
db.Mst_Tokos.Add(toko);
db.SaveChanges();
}
else
{
Toko toko = db.Mst_Tokos.Where(o => o.Id == model.Id).FirstOrDefault();
if (toko != null)
{
toko.Nama = model.Nama;
toko.Alamat = model.Alamat;
toko.NoTelp = model.NoTelp;
toko.ModifiedBy = "Rio";
toko.ModifiedDate = DateTime.Now;
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
result = false;
Message = ex.Message;
}
return(result);
}
public static bool DeleteById(int id)
{
bool result = true;
try
{
using (var db = new PosContext())
{
Barang barang = db.Mst_Barangs.Where(d => d.Id == id).FirstOrDefault();
db.Mst_Barangs.Remove(barang);
db.SaveChanges();
}
}
catch (Exception ex)
{
result = false;
Message = ex.Message;
}
return(result);
}
public static DetailReturPenjualanViewModel GetDetailById(int id)
{
DetailReturPenjualanViewModel result = new DetailReturPenjualanViewModel();
using (var db = new PosContext())
{
result = (from b in db.Mst_Barangs
where b.Id == id
select new DetailReturPenjualanViewModel
{
IdBarang = b.Id,
//IdSupplier = d.IdSupplier,
CodeBarang = b.Code,
Deskripsi = b.Deskripsi,
//Stok = b.Stok,
HargaPenjualan = b.HargaPenjualan
}).FirstOrDefault();
}
return(result);
}
public List <Product> GetProducts(int orderID)
{
int id = 0;
List <Product> returnList = new List <Product>();
using (var db = new PosContext())
{
id = (from o in db.Orders
where o.OrderID == orderID
select o.OrderID).FirstOrDefault();
}
foreach (var item in currentOrders)
{
if (item.OrderID == id)
{
returnList = item.currentProducts;
}
}
return(returnList);
}
public static DetailReceivedOrderViewModel GetDetailById(int id)
{
DetailReceivedOrderViewModel result = new DetailReceivedOrderViewModel();
using (var db = new PosContext())
{
result = (from b in db.Mst_Barangs
join dbr in db.Mst_DetailBarangs
on b.Id equals dbr.IdBarang
where b.Id == id
select new DetailReceivedOrderViewModel
{
IdBarang = b.Id,
//IdSupplier = d.IdSupplier,
CodeBarang = b.Code,
Deskripsi = b.Deskripsi,
//Stok = b.Stok,
HargaPembelian = dbr.HargaPembelian
}).FirstOrDefault();
}
return(result);
}
public void CustomerInsertTest()
{
PosContext db = new PosContext();
Customer newCustomer =
new Customer
{
Name = "Test1", Address = "TestAddress", Creditlimit = 1000
};
db.Customer.Add(newCustomer);
db.SaveChanges();
//using System.Linq; //using System.Data; //using System.Data.Entity;
Customer findCustomer =
db.Customer.Where(C => C.Name == "Test1").FirstOrDefault();
Assert.AreEqual(newCustomer.Name, findCustomer.Name);
if (findCustomer != null)
{
db.Customer.Remove(findCustomer); // remove from Db
}
}
internal static SingleUseEntity GenerateUniqueCode(string email, string userType)
{
Agency agency = GetCurrentUser();
using (var ctx = new PosContext())
{
var model = from s in ctx.SingleUse
where s.email == email
select s;
if (model.Any())
{
var singleusecode = model.FirstOrDefault();
if (singleusecode != null)
{
singleusecode.SUC = Guid.NewGuid();
ctx.SaveChanges();
return singleusecode;
}
}
var suc = new SingleUseEntity
{
AgencyId = agency.Id,
SUC = Guid.NewGuid(),
GeneratedCodeTime = DateTime.UtcNow,
email = email,
UserType = userType
};
ctx.SingleUse.Add(suc);
ctx.SaveChanges();
return suc;
}
}
public static bool HapusBarang(DetailPenjualanViewModel model)
{
bool result = true;
try
{
using (var db = new PosContext())
{
DetailPenjualan es = db.Trans_DetailPenjualans.Where(o => o.IdHeaderPenjualan == model.IdHeaderPenjualan && o.IdBarang == model.IdBarang).FirstOrDefault();
if (es != null)
{
db.Trans_DetailPenjualans.Remove(es);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
}
return(result);
}
public static SingleUseEntity CheckSUCValid(string guid)
{
try
{
using (var ctx = new PosContext())
{
var found = ctx.SingleUse.FirstOrDefault(a => a.SUC.ToString() == guid);
if (found != null)
{
return found;
}
return null;//code is not found so not in db
}
}
catch (Exception ex)
{
return null;
}
}
public static BarangViewModel GetById(int id)
{
BarangViewModel result = new BarangViewModel();
using (var db = new PosContext())
{
result = (from brg in db.Mst_Barangs
//join sup in db.Mst_Suppliers
//on brg.IdSupplier equals sup.Id
select new BarangViewModel
{
Id = brg.Id,
Code = brg.Code,
//IdSupplier=brg.IdSupplier,
//NamaSupplier = sup.Nama,
Deskripsi = brg.Deskripsi,
//Harga=brg.Harga,
//Stok=brg.Stok,
IsActivated = brg.IsActivated
}).FirstOrDefault();
}
return(result);
}
public static int CreateProperty(Property entity)
{
try
{
using (var ctx = new PosContext())
{
var found = ctx.Property.FirstOrDefault(a => a.Id == entity.Id);
if (found == null)
{
var model = ctx.Property.Add(entity);
ctx.SaveChanges();
return model.Id;
}
return -1;
}
}
catch (Exception ex)
{
return -1;
}
}
public static Landlord AddNewLandlord(Landlord entity)
{
try
{
using (var ctx = new PosContext())
{
Agency thisAgency = GlobalVariables.GetAgentsAgency;
AgencyLandlords AgencyLandlord = new AgencyLandlords
{
AgencyId = thisAgency.Id,
LandlordId = entity.Id
};
ctx.AgencyLandlords.Add(AgencyLandlord);
ctx.SaveChanges();
return (entity);
}
}
catch (Exception ex)
{
return null;
}
}
public static bool CreateAgent(Agent agent)
{
try
{
using (var ctx = new PosContext())
{
var found = ctx.Agent.FirstOrDefault(a => a.UserId == agent.UserId);
if (found == null)
{
ctx.Agent.Add(agent);
ctx.SaveChanges();
return true;
}
return false;
}
}
catch (Exception ex)
{
return false;
}
}
public static bool InsertLogArchive(Log log)
{
try
{
using (var ctx = new PosContext())
{
log.Archived = true;
//get email of logged on user --cast agency to user?!?!?
var email = GlobalVariables.CurrentUserEmail;
if (log != null)
{
var archive = new LogArchive
{
Log = log,
DateTimeArchived = DateTime.Now,
ArchivedByUserEmail = email
};
ctx.LogArchive.Add(archive);
ctx.SaveChanges();
return true;
}
}
}
catch (Exception ex)
{
return false;
}
return false;
}
public static bool UpdateLog(Log entity)
{
try
{
using (var ctx = new PosContext())
{
if (entity == null) throw new ArgumentNullException("Log not found with Id " + entity.Id);
InsertLogArchive(entity);
ctx.Entry(entity).State = EntityState.Modified;
ctx.SaveChanges();
return true;
}
}
catch (Exception ex)
{
return false;
}
}
public static List<Log> GetUserLogs(string email)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.Log.Where(l => l.CreatedByEmail == email).
Include(l => l.Property).
Include(l => l.AssignedContractor).ToList();
return (model);
}
}
catch (Exception ex)
{
return null;
}
}
public static List<Landlord> GetAgencyLandlords(int? agencyId)
{
try
{
using (var ctx = new PosContext())
{
List<Landlord> agencyLandlords = new List<Landlord>();
var model = ctx.AgencyLandlords.Where(l => l.AgencyId == agencyId).ToList();
foreach (var l in model)
{
var landlord = ctx.Landlord.FirstOrDefault(landl => landl.Id == l.LandlordId);
landlord.Forename = landlord.Forename + " " + landlord.Lastname;
agencyLandlords.Add(landlord);
}
return (agencyLandlords);
}
}
catch (Exception ex)
{
return null;
}
}
public static Agency GetAgencyById(int id)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.Agency.FirstOrDefault(l => l.Id == id);
return model;
}
}
catch (Exception ex)
{
return null;
}
}
public static Tenant GetTenantByEmail(string email)
{
try
{
using (var ctx = new PosContext())
{
var model = ctx.Tenant.FirstOrDefault(l => l.Email == email);
return model;
}
}
catch (Exception ex)
{
return null;
}
}
