public Interface.IprivetCustomer Find(int id)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var privetCustomer = dbContext.tblPrivateCustomers.SingleOrDefault(
x => x.privateCustomersNo == id);
return(new InterfaceAdaptor.PrivetCustomer()
{
Active = (bool)privetCustomer.active,
AltPhoneNo = privetCustomer.altPhoneNo,
Email = privetCustomer.email,
HomeAddress = privetCustomer.homeAddress,
Name = privetCustomer.name,
PhoneNo = privetCustomer.phoneNo,
PostNo = new InterfaceAdaptor.PostNo()
{
City = privetCustomer.tblPostNo.city,
Id = privetCustomer.tblPostNo.ID,
PostNumber = privetCustomer.tblPostNo.postNo
},
PrivateCustomersNo = privetCustomer.privateCustomersNo,
Surname = privetCustomer.surname,
});
}
}
public void Delete(int id)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var bankAccountsDeleteing = dbContext.tblBankAccounts.SingleOrDefault(
x => x.Id == id);
var deleteInfo = new StringBuilder();
deleteInfo.Append("[tblBankAccounts] { ");
deleteInfo.Append("indexId = " + bankAccountsDeleteing.Id.ToString() + ", ");
deleteInfo.Append("bank = " + bankAccountsDeleteing.bank + ", ");
deleteInfo.Append("accountName = " + bankAccountsDeleteing.accountName + ", ");
deleteInfo.Append("regNo = " + bankAccountsDeleteing.regNo.ToString() + ", ");
deleteInfo.Append("accountNo = " + bankAccountsDeleteing.accountNo + ", ");
deleteInfo.Append("balance = " + bankAccountsDeleteing.balance.ToString() + " }");
var deleteingItem = new tblDeleteItem()
{
deleteDate = DateTime.Now,
itemInfo = deleteInfo.ToString(),
restored = false
};
dbContext.tblBankAccounts.DeleteOnSubmit(bankAccountsDeleteing);
dbContext.tblDeleteItems.InsertOnSubmit(deleteingItem);
dbContext.SubmitChanges();
}
}
public void Delete(int id)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var workerStatusDeleteing = dbContext.tblWorkerStatus.SingleOrDefault(
x => x.statusNo == id);
var workerStatusDeletInfo = new StringBuilder();
workerStatusDeletInfo.Append("[tblWorkerStatus] { ");
workerStatusDeletInfo.Append("statusNo = " + workerStatusDeleteing.statusNo.ToString() + ", ");
workerStatusDeletInfo.Append("status = " + workerStatusDeleteing.status + " }");
var newDelete = new tblDeleteItem()
{
deleteDate = DateTime.Now,
itemInfo = workerStatusDeletInfo.ToString(),
restored = false
};
dbContext.tblDeleteItems.InsertOnSubmit(newDelete);
dbContext.tblWorkerStatus.DeleteOnSubmit(workerStatusDeleteing);
dbContext.SubmitChanges();
}
}
public List <Interface.IcompanyOrder> Get(bool?paid)
{
var list = new List <Interface.IcompanyOrder>();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
IQueryable <tblCompanyOrder> companyOrders;
if (paid == null)
{
companyOrders = from tblCompanyOrder in dbContext.tblCompanyOrders
select tblCompanyOrder;
}
else
{
companyOrders = from tblCompanyOrder in dbContext.tblCompanyOrders
where tblCompanyOrder.paid == paid
select tblCompanyOrder;
}
foreach (var item in companyOrders)
{
list.Add(TblCompanyOrderToCompanyOrder(item));
}
}
return(list);
}
public void Update(Interface.IinvoiceCompany obj)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var updateing = dbContext.tblInvoiceCompanies.SingleOrDefault(
x => x.Id == obj.Id);
updateing.Active = obj.Active;
updateing.OrderNr1 = obj.Order[0];
updateing.OrderNr2 = obj.Order[1];
updateing.OrderNr3 = obj.Order[2];
updateing.OrderNr4 = obj.Order[3];
updateing.OrderNr5 = obj.Order[4];
updateing.OrderNr6 = obj.Order[5];
updateing.OrderNr7 = obj.Order[6];
updateing.OrderNr8 = obj.Order[7];
updateing.OrderNr9 = obj.Order[8];
updateing.OrderNr10 = obj.Order[9];
updateing.OrderNr11 = obj.Order[10];
updateing.OrderNr12 = obj.Order[11];
updateing.OrderNr13 = obj.Order[12];
updateing.OrderNr14 = obj.Order[13];
updateing.OrderNr15 = obj.Order[14];
updateing.OrderNr16 = obj.Order[15];
updateing.OrderNr17 = obj.Order[16];
updateing.OrderNr18 = obj.Order[17];
updateing.OrderNr19 = obj.Order[18];
updateing.OrderNr20 = obj.Order[19];
dbContext.SubmitChanges();
}
}
public List <Interface.IprivetOrder> GetBaseCustomer(int id, bool?paid)
{
var list = new List <Interface.IprivetOrder>();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
IQueryable <tblPrivetOrder> privetOrders;
if (paid == null)
{
privetOrders = from tblPrivetOrder in dbContext.tblPrivetOrders
where tblPrivetOrder.customers == id
select tblPrivetOrder;
}
else
{
privetOrders = from tblPrivetOrder in dbContext.tblPrivetOrders
where tblPrivetOrder.customers == id && tblPrivetOrder.paid == paid
select tblPrivetOrder;
}
foreach (var item in privetOrders)
{
list.Add(tblPrivetOrderToPrivetOrder(item));
}
}
return(list);
}
public int[] OrdersInUse(int orderId)
{
int[] inUse = null;
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
IQueryable <tblInvoicePrivet> dbList;
dbList = from tblInvoicePrivet in dbContext.tblInvoicePrivets
where
tblInvoicePrivet.OrderNr1 == orderId || tblInvoicePrivet.OrderNr2 == orderId ||
tblInvoicePrivet.OrderNr3 == orderId || tblInvoicePrivet.OrderNr4 == orderId ||
tblInvoicePrivet.OrderNr5 == orderId || tblInvoicePrivet.OrderNr6 == orderId ||
tblInvoicePrivet.OrderNr7 == orderId || tblInvoicePrivet.OrderNr8 == orderId ||
tblInvoicePrivet.OrderNr9 == orderId || tblInvoicePrivet.OrderNr10 == orderId ||
tblInvoicePrivet.OrderNr11 == orderId || tblInvoicePrivet.OrderNr12 == orderId ||
tblInvoicePrivet.OrderNr13 == orderId || tblInvoicePrivet.OrderNr14 == orderId ||
tblInvoicePrivet.OrderNr15 == orderId || tblInvoicePrivet.OrderNr16 == orderId ||
tblInvoicePrivet.OrderNr17 == orderId || tblInvoicePrivet.OrderNr18 == orderId ||
tblInvoicePrivet.OrderNr19 == orderId || tblInvoicePrivet.OrderNr20 == orderId
select tblInvoicePrivet;
var list = new List <int>();
foreach (var item in dbList)
{
list.Add(item.Id);
}
inUse = list.ToArray <int>();
}
return(inUse);
}
public void Add(Interface.IprivetOrder privetOrder)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var newPrivetOrderFound = new tblPrivetOrder()
{
createBy = privetOrder.CreateBy.WorkNo,
createdDate = privetOrder.CreateDate,
customers = privetOrder.Customer.PrivateCustomersNo,
dateSendBill = privetOrder.DateSendBill,
daysToPaid = privetOrder.DaysToPaid,
descriptionTask = privetOrder.DescriptionTask,
hoursUse = Convert.ToDecimal(privetOrder.HourUse),
paid = privetOrder.Paid,
paidHour = Convert.ToDecimal(privetOrder.PaidHour),
paidToACC = privetOrder.PaidToAcc,
taskDate = privetOrder.TaskDate,
};
if (newPrivetOrderFound.dateSendBill != null)
{
if (newPrivetOrderFound.dateSendBill.Value.Year == 1)
{
newPrivetOrderFound.dateSendBill = null;
}
}
dbContext.tblPrivetOrders.InsertOnSubmit(newPrivetOrderFound);
dbContext.SubmitChanges();
}
}
public int[] OrdersInUse(int id)
{
List <int> list = new List <int>();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
IQueryable <tblInvoiceCompany> dbList;
dbList = from tblInvoiceCompany in dbContext.tblInvoiceCompanies
where
tblInvoiceCompany.OrderNr1 == id || tblInvoiceCompany.OrderNr2 == id ||
tblInvoiceCompany.OrderNr3 == id || tblInvoiceCompany.OrderNr4 == id ||
tblInvoiceCompany.OrderNr5 == id || tblInvoiceCompany.OrderNr6 == id ||
tblInvoiceCompany.OrderNr7 == id || tblInvoiceCompany.OrderNr8 == id ||
tblInvoiceCompany.OrderNr9 == id || tblInvoiceCompany.OrderNr10 == id ||
tblInvoiceCompany.OrderNr11 == id || tblInvoiceCompany.OrderNr12 == id ||
tblInvoiceCompany.OrderNr13 == id || tblInvoiceCompany.OrderNr14 == id ||
tblInvoiceCompany.OrderNr15 == id || tblInvoiceCompany.OrderNr16 == id ||
tblInvoiceCompany.OrderNr17 == id || tblInvoiceCompany.OrderNr18 == id ||
tblInvoiceCompany.OrderNr19 == id || tblInvoiceCompany.OrderNr20 == id
select tblInvoiceCompany;
foreach (var item in dbList)
{
list.Add(item.Id);
}
}
return(list.ToArray <int>());
}
public Interface.Idepartment Find(int deparmentNo)
{
var department = new InterfaceAdaptor.Department();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var item = dbContext.tblDepartments.SingleOrDefault(x => x.department == deparmentNo);
department.Active = (bool)item.active;
department.Address = item._address;
department.AltPhoneNo = item.altPhoneNo;
department.CompanyName = item.companyName;
department.CvrNo = item.cvrNo;
department.Deparment = item.department;
department.Email = item.email;
department.PhoneNo = item.phoneNo;
#region department => DeparmentHead : Worker
department.DeparmentHead = new InterfaceAdaptor.Worker()
{
Active = (bool)item.tblWorker.active,
Address = item.tblWorker.homeAddress,
AltPhoneNo = item.tblWorker.altPhoneNo,
Email = item.tblWorker.email,
Name = item.tblWorker.name,
PhoneNo = item.tblWorker.phoneNo,
Surname = item.tblWorker.surname,
WorkNo = item.tblWorker.workNo,
#region DeparmentHead => Post number
PostNo = new InterfaceAdaptor.PostNo()
{
City = item.tblWorker.tblPostNo.city,
Id = item.tblWorker.tblPostNo.ID,
PostNumber = item.tblWorker.tblPostNo.postNo
},
#endregion
#region DeparmentHead => Worker Status
WorkerStatus = new InterfaceAdaptor.WorkerStatus()
{
Staus = item.tblWorker.tblWorkerStatus.status,
StautsNo = item.tblWorker.tblWorkerStatus.statusNo
}
#endregion
};
#endregion
//88
department.PostNo = new InterfaceAdaptor.PostNo()
{
City = item.tblPostNo.city,
Id = item.tblPostNo.ID,
PostNumber = item.tblPostNo.postNo
};
}
return(department);
}
public Interface.IcompanyCustomer Find(int id)
{
Interface.IcompanyCustomer companyCustomer;
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var companyCustomerFound = dbContext.tblCompanyCustomers.SingleOrDefault(
x => x.companyCustomersNo == id);
companyCustomer = new InterfaceAdaptor.CompanyCustomer()
{
Active = (bool)companyCustomerFound.active,
Address = companyCustomerFound._address,
AltPhoneNo = companyCustomerFound.altPhoneNo,
CompanyCustomersNo = companyCustomerFound.companyCustomersNo,
ContactPerson = companyCustomerFound.companyContactPerson,
CvrNo = companyCustomerFound.cvrNo,
Email = companyCustomerFound.email,
Name = companyCustomerFound.companyName,
PhoneNo = companyCustomerFound.phoneNo,
PostNo = new InterfaceAdaptor.PostNo()
{
City = companyCustomerFound.tblPostNo.city,
Id = companyCustomerFound.tblPostNo.ID,
PostNumber = companyCustomerFound.tblPostNo.postNo
},
};
}
return(companyCustomer);
}
public void Add(Interface.IinvoiceCompany obj)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var newInvoice = new tblInvoiceCompany()
{
Active = obj.Active,
Id = obj.Id,
OrderNr1 = obj.Order[0],
OrderNr2 = obj.Order[1],
OrderNr3 = obj.Order[2],
OrderNr4 = obj.Order[3],
OrderNr5 = obj.Order[4],
OrderNr6 = obj.Order[5],
OrderNr7 = obj.Order[6],
OrderNr8 = obj.Order[7],
OrderNr9 = obj.Order[8],
OrderNr10 = obj.Order[9],
OrderNr11 = obj.Order[10],
OrderNr12 = obj.Order[11],
OrderNr13 = obj.Order[12],
OrderNr14 = obj.Order[13],
OrderNr15 = obj.Order[14],
OrderNr16 = obj.Order[15],
OrderNr17 = obj.Order[16],
OrderNr18 = obj.Order[17],
OrderNr19 = obj.Order[18],
OrderNr20 = obj.Order[19],
};
dbContext.tblInvoiceCompanies.InsertOnSubmit(newInvoice);
dbContext.SubmitChanges();
}
}
public List <Interface.IinvoiceCompany> Get(bool?active)
{
var list = new List <Interface.IinvoiceCompany>();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
IQueryable <tblInvoiceCompany> dbList;
if (active == null)
{
dbList = from tblInvoiceCompany in dbContext.tblInvoiceCompanies
select tblInvoiceCompany;
}
else
{
dbList = from tblInvoiceCompany in dbContext.tblInvoiceCompanies
where tblInvoiceCompany.Active == (bool)active
select tblInvoiceCompany;
}
InterfaceAdaptor.InvoiceCompany tempInvoice;
foreach (var item in dbList)
{
tempInvoice = new InterfaceAdaptor.InvoiceCompany();
tempInvoice.Active = item.Active;
tempInvoice.Id = item.Id;
tempInvoice.Order = new int?[20];
tempInvoice.Order[0] = item.OrderNr1;
tempInvoice.Order[1] = item.OrderNr2;
tempInvoice.Order[2] = item.OrderNr3;
tempInvoice.Order[3] = item.OrderNr4;
tempInvoice.Order[4] = item.OrderNr5;
tempInvoice.Order[5] = item.OrderNr6;
tempInvoice.Order[6] = item.OrderNr7;
tempInvoice.Order[7] = item.OrderNr8;
tempInvoice.Order[8] = item.OrderNr9;
tempInvoice.Order[9] = item.OrderNr10;
tempInvoice.Order[10] = item.OrderNr11;
tempInvoice.Order[11] = item.OrderNr12;
tempInvoice.Order[12] = item.OrderNr13;
tempInvoice.Order[13] = item.OrderNr14;
tempInvoice.Order[14] = item.OrderNr15;
tempInvoice.Order[15] = item.OrderNr16;
tempInvoice.Order[16] = item.OrderNr17;
tempInvoice.Order[17] = item.OrderNr18;
tempInvoice.Order[18] = item.OrderNr19;
tempInvoice.Order[19] = item.OrderNr20;
list.Add(tempInvoice);
}
}
return(list);
}
public List <Interface.Iworker> Get(bool?active)
{
var list = new List <Interface.Iworker>();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
IQueryable <tblWorker> workers;
if (active == null)
{
workers = from tblWorker in dbContext.tblWorkers
select tblWorker;
}
else
{
workers = from tblWorker in dbContext.tblWorkers
where tblWorker.active == active
select tblWorker;
}
foreach (var item in workers)
{
#region worker
var worker = new InterfaceAdaptor.Worker()
{
Active = (bool)item.active,
Address = item.homeAddress,
AltPhoneNo = item.altPhoneNo,
Email = item.email,
Name = item.name,
PhoneNo = item.phoneNo,
#region Post number => worker
PostNo = new InterfaceAdaptor.PostNo()
{
City = item.tblPostNo.city,
Id = item.tblPostNo.ID,
PostNumber = item.tblPostNo.postNo
},
#endregion
Surname = item.surname,
#region Worker Status => worker
WorkerStatus = new InterfaceAdaptor.WorkerStatus()
{
Staus = item.tblWorkerStatus.status,
StautsNo = item.tblWorkerStatus.statusNo
},
#endregion
WorkNo = item.workNo
};
#endregion
list.Add(worker);
}
}
return(list);
}
public List <Interface.IinvoicePrivet> Get(bool?active)
{
var list = new List <Interface.IinvoicePrivet>();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
IQueryable <tblInvoicePrivet> dbList;
if (active == null)
{
dbList = from tblInvoicePrivet in dbContext.tblInvoicePrivets
select tblInvoicePrivet;
}
else
{
dbList = from tblInvoicePrivet in dbContext.tblInvoicePrivets
where tblInvoicePrivet.Active == (bool)active
select tblInvoicePrivet;
}
foreach (var item in dbList)
{
list.Add(new InterfaceAdaptor.InvoicePrivet()
{
Active = item.Active,
Id = item.Id,
Order = new int?[]
{
item.OrderNr1,
item.OrderNr2,
item.OrderNr3,
item.OrderNr4,
item.OrderNr5,
item.OrderNr6,
item.OrderNr7,
item.OrderNr8,
item.OrderNr9,
item.OrderNr10,
item.OrderNr11,
item.OrderNr12,
item.OrderNr13,
item.OrderNr14,
item.OrderNr15,
item.OrderNr16,
item.OrderNr17,
item.OrderNr18,
item.OrderNr19,
item.OrderNr20,
}
});
}
}
return(list);
}
public void Update(Interface.IpostNo postNumber)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
tblPostNo postNo = dbContext.tblPostNos.SingleOrDefault(x => x.ID == postNumber.Id);
postNo.city = postNumber.City;
postNo.postNo = postNumber.PostNumber;
dbContext.SubmitChanges();
}
}
public void Update(Interface.IworkerStatus workerStatus)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var workerStatusUpdateing = dbContext.tblWorkerStatus.SingleOrDefault(
x => x.statusNo == workerStatus.StautsNo);
workerStatusUpdateing.status = workerStatus.Staus;
dbContext.SubmitChanges();
}
}
public void Delete(int id)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var deleteing = dbContext.tblInvoiceCompanies.SingleOrDefault(
x => x.Id == id);
var deleteInfo = new StringBuilder();
deleteInfo.Append("[tblInvoiceCompany] { ");
deleteInfo.Append("ID = " + deleteing.Id.ToString() + ", ");
deleteInfo.Append("Active = ");
if (deleteing.Active)
{
deleteInfo.Append("1");
}
else
{
deleteInfo.Append("1");
}
deleteInfo.Append(", ");
deleteInfo.Append("OrderNr1 = " + deleteing.OrderNr1.ToString() + ", ");
deleteInfo.Append("OrderNr2 = " + deleteing.OrderNr2.ToString() + ", ");
deleteInfo.Append("OrderNr3 = " + deleteing.OrderNr3.ToString() + ", ");
deleteInfo.Append("OrderNr4 = " + deleteing.OrderNr4.ToString() + ", ");
deleteInfo.Append("OrderNr5 = " + deleteing.OrderNr5.ToString() + ", ");
deleteInfo.Append("OrderNr6 = " + deleteing.OrderNr6.ToString() + ", ");
deleteInfo.Append("OrderNr7 = " + deleteing.OrderNr7.ToString() + ", ");
deleteInfo.Append("OrderNr8 = " + deleteing.OrderNr8.ToString() + ", ");
deleteInfo.Append("OrderNr9 = " + deleteing.OrderNr9.ToString() + ", ");
deleteInfo.Append("OrderNr10 = " + deleteing.OrderNr10.ToString() + ", ");
deleteInfo.Append("OrderNr11 = " + deleteing.OrderNr11.ToString() + ", ");
deleteInfo.Append("OrderNr12 = " + deleteing.OrderNr12.ToString() + ", ");
deleteInfo.Append("OrderNr13 = " + deleteing.OrderNr13.ToString() + ", ");
deleteInfo.Append("OrderNr14 = " + deleteing.OrderNr14.ToString() + ", ");
deleteInfo.Append("OrderNr15 = " + deleteing.OrderNr15.ToString() + ", ");
deleteInfo.Append("OrderNr16 = " + deleteing.OrderNr16.ToString() + ", ");
deleteInfo.Append("OrderNr17 = " + deleteing.OrderNr17.ToString() + ", ");
deleteInfo.Append("OrderNr18 = " + deleteing.OrderNr18.ToString() + ", ");
deleteInfo.Append("OrderNr19 = " + deleteing.OrderNr19.ToString() + ", ");
deleteInfo.Append("OrderNr20 = " + deleteing.OrderNr20.ToString() + " }");
dbContext.tblDeleteItems.InsertOnSubmit(new tblDeleteItem()
{
deleteDate = DateTime.Now,
itemInfo = deleteInfo.ToString(),
restored = false
});
dbContext.tblInvoiceCompanies.DeleteOnSubmit(deleteing);
dbContext.SubmitChanges();
}
}
public void Add(Interface.IworkerStatus workerStatus)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var newWorkerStatus = new tblWorkerStatus()
{
status = workerStatus.Staus
};
dbContext.tblWorkerStatus.InsertOnSubmit(newWorkerStatus);
dbContext.SubmitChanges();
}
}
public void Add(Interface.IpostNo postNumber)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
tblPostNo newPostNumber = new tblPostNo
{
postNo = postNumber.PostNumber,
city = postNumber.City
};
dbContext.tblPostNos.InsertOnSubmit(newPostNumber);
dbContext.SubmitChanges();
}
}
public void Update(Interface.Iworker worker)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
tblWorker updateWorker = dbContext.tblWorkers.SingleOrDefault(
x => x.workNo == worker.WorkNo);
updateWorker.active = worker.Active;
updateWorker.altPhoneNo = worker.AltPhoneNo;
if (worker.Email != string.Empty)
{
updateWorker.email = worker.Email;
}
if (worker.Email != string.Empty)
{
updateWorker.homeAddress = worker.Address;
}
if (worker.Name != string.Empty)
{
updateWorker.name = worker.Name;
}
if (worker.PhoneNo != string.Empty)
{
updateWorker.phoneNo = worker.PhoneNo;
}
if (worker.PhoneNo != null)
{
updateWorker.postNo = worker.PostNo.Id;
}
if (worker.Surname != string.Empty)
{
updateWorker.surname = worker.Surname;
}
if (worker.WorkerStatus != null)
{
updateWorker.workerStatus = worker.WorkerStatus.StautsNo;
}
dbContext.SubmitChanges();
}
}
public Interface.IworkerStatus Find(int stautsNumber)
{
var workerStatus = new InterfaceAdaptor.WorkerStatus();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var workerStatusFound = dbContext.tblWorkerStatus.SingleOrDefault(
x => x.statusNo == stautsNumber);
workerStatus.Staus = workerStatusFound.status;
workerStatus.StautsNo = workerStatusFound.statusNo;
}
return(workerStatus);
}
public void Update(Interface.IbankAccounts bankAccounts)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var bankAccUpdateing = dbContext.tblBankAccounts.SingleOrDefault(
x => x.Id == bankAccounts.Id);
bankAccUpdateing.accountName = bankAccounts.AccountName;
bankAccUpdateing.accountNo = bankAccounts.AccountNo;
bankAccUpdateing.balance = Convert.ToDecimal(bankAccounts.Balance);
bankAccUpdateing.bank = bankAccounts.Bank;
bankAccUpdateing.regNo = bankAccounts.RegNo;
dbContext.SubmitChanges();
}
}
public List <Interface.IprivetCustomer> Get(bool?active)
{
var list = new List <Interface.IprivetCustomer>();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
IQueryable <tblPrivateCustomer> tblPrivateCustomers;
if (active == null)
{
tblPrivateCustomers = from tblPrivateCustomer in dbContext.tblPrivateCustomers
select tblPrivateCustomer;
}
else
{
tblPrivateCustomers = from tblPrivateCustomer in dbContext.tblPrivateCustomers
where tblPrivateCustomer.active == active
select tblPrivateCustomer;
}
foreach (var item in tblPrivateCustomers)
{
var PrivateCustomer = new InterfaceAdaptor.PrivetCustomer()
{
Active = (bool)item.active,
AltPhoneNo = item.altPhoneNo,
Email = item.email,
HomeAddress = item.homeAddress,
Name = item.name,
PhoneNo = item.phoneNo,
PostNo = new InterfaceAdaptor.PostNo()
{
City = item.tblPostNo.city,
Id = item.tblPostNo.ID,
PostNumber = item.tblPostNo.postNo
},
PrivateCustomersNo = item.privateCustomersNo,
Surname = item.surname,
};
list.Add(PrivateCustomer);
}
}
return(list);
}
public Interface.IpostNo Find(int id)
{
var postNumber = new InterfaceAdaptor.PostNo();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var postNumbersTbl = dbContext.tblPostNos;
var postNo = postNumbersTbl.SingleOrDefault(x => x.ID == id);
postNumber.City = postNo.city;
postNumber.Id = postNo.ID;
postNumber.PostNumber = postNo.postNo;
}
return(postNumber);
}
public void Add(Interface.IbankAccounts bankAccounts)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var newBankAcc = new tblBankAccount()
{
accountName = bankAccounts.AccountName,
accountNo = bankAccounts.AccountNo,
balance = Convert.ToDecimal(bankAccounts.Balance),
bank = bankAccounts.Bank,
regNo = bankAccounts.RegNo,
};
dbContext.tblBankAccounts.InsertOnSubmit(newBankAcc);
dbContext.SubmitChanges();
}
}
public List <Interface.IcompanyCustomer> Get(bool?active)
{
var list = new List <Interface.IcompanyCustomer>();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
IQueryable <tblCompanyCustomer> companyCustomers;
if (active == null)
{
companyCustomers = from tblCompanyCustomer in dbContext.tblCompanyCustomers
select tblCompanyCustomer;
}
else
{
companyCustomers = from tblCompanyCustomer in dbContext.tblCompanyCustomers
where tblCompanyCustomer.active == active
select tblCompanyCustomer;
}
foreach (var item in companyCustomers)
{
list.Add(new InterfaceAdaptor.CompanyCustomer()
{
Active = (bool)item.active,
Address = item._address,
AltPhoneNo = item.altPhoneNo,
CompanyCustomersNo = item.companyCustomersNo,
ContactPerson = item.companyContactPerson,
CvrNo = item.cvrNo,
Email = item.email,
Name = item.companyName,
PhoneNo = item.phoneNo,
PostNo = new InterfaceAdaptor.PostNo()
{
City = item.tblPostNo.city,
Id = item.tblPostNo.ID,
PostNumber = item.tblPostNo.postNo
}
});
}
}
return(list);
}
public void Update(Interface.IcompanyCustomer companyCustomer)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var companyCustomerUpdateing = dbContext.tblCompanyCustomers.SingleOrDefault(
x => x.companyCustomersNo == companyCustomer.CompanyCustomersNo);
if (companyCustomer.Address != string.Empty)
{
companyCustomerUpdateing._address = companyCustomer.Address;
}
companyCustomerUpdateing.active = companyCustomer.Active;
companyCustomerUpdateing.altPhoneNo = companyCustomer.AltPhoneNo;
if (companyCustomer.ContactPerson != string.Empty)
{
companyCustomerUpdateing.companyContactPerson = companyCustomer.ContactPerson;
}
if (companyCustomer.Name != string.Empty)
{
companyCustomerUpdateing.companyName = companyCustomer.Name;
}
if (companyCustomer.CvrNo != -1)
{
companyCustomerUpdateing.cvrNo = companyCustomer.CvrNo;
}
companyCustomerUpdateing.email = companyCustomer.Email;
if (companyCustomer.PhoneNo != string.Empty)
{
companyCustomerUpdateing.phoneNo = companyCustomer.PhoneNo;
}
if (companyCustomer.PostNo.Id != -1)
{
companyCustomerUpdateing.postNo = companyCustomer.PostNo.Id;
}
dbContext.SubmitChanges();
}
}
public void Update(Interface.IprivetCustomer privetCustomer)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var privetCustomerUpdateing = dbContext.tblPrivateCustomers.SingleOrDefault(
x => x.privateCustomersNo == privetCustomer.PrivateCustomersNo);
privetCustomerUpdateing.active = privetCustomer.Active;
privetCustomerUpdateing.altPhoneNo = privetCustomer.AltPhoneNo;
privetCustomerUpdateing.email = privetCustomer.Email;
privetCustomerUpdateing.homeAddress = privetCustomer.HomeAddress;
privetCustomerUpdateing.name = privetCustomer.Name;
privetCustomerUpdateing.phoneNo = privetCustomer.PhoneNo;
privetCustomerUpdateing.postNo = privetCustomer.PostNo.Id;
privetCustomerUpdateing.surname = privetCustomer.Surname;
dbContext.SubmitChanges();
}
}
public bool UpdateActive(int id, bool active)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var item = dbContext.tblInvoiceCompanies.SingleOrDefault(
x => x.Id == id);
if (item == null)
{
return(false);
}
item.Active = active;
dbContext.SubmitChanges();
}
return(true);
}
