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 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 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 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 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 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 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 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 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 Delete(int id)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var companyOrderDeleteing = dbContext.tblCompanyOrders.SingleOrDefault(
x => x.invoiceNo == id);
var deleteInfo = new StringBuilder();
deleteInfo.Append("[tblCompanyOrders] { ");
deleteInfo.Append("invoiceNo = " + companyOrderDeleteing.ToString() + ", ");
deleteInfo.Append("createdDate = " + companyOrderDeleteing.createdDate.ToString() + ", ");
deleteInfo.Append("taskDate = " + companyOrderDeleteing.taskDate.ToString() + ", ");
deleteInfo.Append("descriptionTask = " + companyOrderDeleteing.descriptionTask + ", ");
deleteInfo.Append("dateSendBill = " + companyOrderDeleteing.dateSendBill.Value.ToShortDateString() + ", ");
deleteInfo.Append("daysToPaid = " + companyOrderDeleteing.daysToPaid.ToString() + ", ");
deleteInfo.Append("hoursUse = " + companyOrderDeleteing.hoursUse.ToString() + ", ");
deleteInfo.Append("paidHour = " + companyOrderDeleteing.paidHour.ToString() + ", ");
deleteInfo.Append("createBy = " + companyOrderDeleteing.createBy.ToString() + ", ");
deleteInfo.Append("paidToACC = " + companyOrderDeleteing.paidToACC.ToString() + ", ");
deleteInfo.Append("customer = " + companyOrderDeleteing.customer.ToString() + ", ");
deleteInfo.Append("paid = ");
if ((bool)companyOrderDeleteing.paid)
{
deleteInfo.Append("1");
}
else
{
deleteInfo.Append("0");
}
deleteInfo.Append(" }");
dbContext.tblDeleteItems.InsertOnSubmit(new tblDeleteItem()
{
deleteDate = DateTime.Now,
itemInfo = deleteInfo.ToString(),
restored = false
});
dbContext.tblCompanyOrders.DeleteOnSubmit(companyOrderDeleteing);
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);
}
public void Delete(int WorkNumber)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
tblWorker workerItem = dbContext.tblWorkers.SingleOrDefault(x => x.workNo == WorkNumber);
var workerDelete = new StringBuilder();
workerDelete.Append("[tblWorkers] { ");
workerDelete.Append("workNo = " + workerItem.workNo.ToString() + ", ");
workerDelete.Append("name = " + workerItem.name + ", ");
workerDelete.Append("surname = " + workerItem.surname + ", ");
workerDelete.Append("workerStatus = " + workerItem.workerStatus.ToString() + ", ");
workerDelete.Append("phoneNo = " + workerItem.phoneNo + ", ");
workerDelete.Append("altPhoneNo = " + workerItem.altPhoneNo + ", ");
workerDelete.Append("homeAddress = " + workerItem.homeAddress + ", ");
workerDelete.Append("postNo = " + workerItem.postNo.ToString() + ", ");
workerDelete.Append("email = " + workerItem.email + ", ");
workerDelete.Append("active = ");
if (workerItem.active == true)
{
workerDelete.Append("1");
}
else
{
workerDelete.Append("0");
}
workerDelete.Append(" }");
var newDeleteItem = new tblDeleteItem()
{
deleteDate = DateTime.Now,
itemInfo = workerDelete.ToString(),
restored = false
};
workerItem.active = false;
dbContext.tblDeleteItems.InsertOnSubmit(newDeleteItem);
dbContext.SubmitChanges();
}
}
public void Delete(int department)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
tblDepartment item = dbContext.tblDepartments.SingleOrDefault(
x => x.department == department);
var itemString = new StringBuilder();
itemString.Append("[tblDepartment] { ");
itemString.Append("department = " + item.department.ToString() + ", ");
itemString.Append("cvrNo = " + item.cvrNo.ToString() + ", ");
itemString.Append("phoneNo = " + item.phoneNo + ", ");
itemString.Append("altPhoneNo = " + item.altPhoneNo + ", ");
itemString.Append("_address = " + item._address + ", ");
itemString.Append("postNo = " + item.postNo.ToString() + ",");
itemString.Append("email = " + item.email + ", ");
if ((bool)item.active)
{
itemString.Append("active = " + "1, ");
}
else
{
itemString.Append("active = " + "1, ");
}
itemString.Append("departmentHeadNo = " + item.departmentHeadNo.ToString() + " }");
var deleteItem = new tblDeleteItem()
{
itemInfo = itemString.ToString(),
deleteDate = DateTime.Now,
restored = false,
};
item.active = false;
dbContext.tblDeleteItems.InsertOnSubmit(deleteItem);
dbContext.SubmitChanges();
}
}
public void Delete(int id)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var deletingItem = dbContext.tblCompanyCustomers.SingleOrDefault(
x => x.companyCustomersNo == id);
var deletingInfo = new StringBuilder();
deletingInfo.Append("[tblCompanyCustomers] { ");
deletingInfo.Append("companyCustomersNo = " + deletingItem.companyCustomersNo.ToString() + ", ");
deletingInfo.Append("companyName = " + deletingItem.companyName + ", ");
deletingInfo.Append("companyContactPerson = " + deletingItem.companyContactPerson + ", ");
deletingInfo.Append("cvrNo = " + deletingItem.cvrNo.ToString() + ", ");
deletingInfo.Append("phoneNo = " + deletingItem.phoneNo + ", ");
deletingInfo.Append("altPhoneNo = " + deletingItem.altPhoneNo + ", ");
deletingInfo.Append("_address = " + deletingItem._address + ", ");
deletingInfo.Append("postNo = " + deletingItem.postNo.ToString() + ", ");
deletingInfo.Append("email = " + deletingItem.email + ", ");
deletingInfo.Append("active = ");
if ((bool)deletingItem.active)
{
deletingInfo.Append("1");
}
else
{
deletingInfo.Append("0");
}
deletingInfo.Append(" }");
deletingItem.active = false;
dbContext.tblDeleteItems.InsertOnSubmit(new tblDeleteItem()
{
deleteDate = DateTime.Now,
itemInfo = deletingInfo.ToString(),
restored = false
});
dbContext.SubmitChanges();
}
}
public void Delete(int id)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var deleteingItem = dbContext.tblPrivateCustomers.SingleOrDefault(
x => x.privateCustomersNo == id);
var deleteingInfo = new StringBuilder();
deleteingInfo.Append("[tblPrivateCustomers] { ");
deleteingInfo.Append("privateCustomersNo = " + deleteingItem.privateCustomersNo.ToString() + ", ");
deleteingInfo.Append("name = " + deleteingItem.name + ", ");
deleteingInfo.Append("surname = " + deleteingItem.surname + ", ");
deleteingInfo.Append("phoneNo = " + deleteingItem.phoneNo + ", ");
deleteingInfo.Append("altPhoneNo = " + deleteingItem.altPhoneNo + ", ");
deleteingInfo.Append("homeAddress = " + deleteingItem.homeAddress + ", ");
deleteingInfo.Append("postNo = " + deleteingItem.postNo.ToString() + ", ");
deleteingInfo.Append("email = " + deleteingItem.email + ", ");
deleteingInfo.Append("active = ");
if (deleteingItem.active == true)
{
deleteingInfo.Append("1");
}
else
{
deleteingInfo.Append("0");
}
deleteingInfo.Append(" }");
var deleteData = new tblDeleteItem()
{
deleteDate = DateTime.Now,
itemInfo = deleteingItem.ToString(),
restored = false
};
deleteingItem.active = false;
dbContext.tblDeleteItems.InsertOnSubmit(deleteData);
dbContext.SubmitChanges();
}
}
public void Update(Interface.Idepartment department)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
tblDepartment updateDepartment = dbContext.tblDepartments.SingleOrDefault(
x => x.department == department.Deparment);
updateDepartment._address = department.Address;
updateDepartment.active = department.Active;
updateDepartment.altPhoneNo = department.AltPhoneNo;
updateDepartment.companyName = department.CompanyName;
updateDepartment.cvrNo = department.CvrNo;
updateDepartment.department = department.Deparment;
updateDepartment.departmentHeadNo = department.DeparmentHead.WorkNo;
updateDepartment.email = department.Email;
updateDepartment.phoneNo = department.PhoneNo;
updateDepartment.postNo = department.PostNo.Id;
dbContext.SubmitChanges();
}
}
public void Add(Interface.Iworker worker)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var newWorker = new tblWorker()
{
active = worker.Active,
altPhoneNo = worker.AltPhoneNo,
email = worker.Email,
homeAddress = worker.Address,
name = worker.Name,
phoneNo = worker.PhoneNo,
postNo = worker.PostNo.Id,
surname = worker.Surname,
workerStatus = worker.WorkerStatus.StautsNo,
};
dbContext.tblWorkers.InsertOnSubmit(newWorker);
dbContext.SubmitChanges();
}
}
public void Add(Interface.IprivetCustomer privetCustomer)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
tblPrivateCustomer newPrivateCustomer = new tblPrivateCustomer()
{
active = privetCustomer.Active,
altPhoneNo = privetCustomer.AltPhoneNo,
email = privetCustomer.Email,
homeAddress = privetCustomer.HomeAddress,
name = privetCustomer.Name,
postNo = privetCustomer.PostNo.Id,
phoneNo = privetCustomer.PhoneNo,
surname = privetCustomer.Surname,
};
dbContext.tblPrivateCustomers.InsertOnSubmit(newPrivateCustomer);
dbContext.SubmitChanges();
}
}
public void Add(Interface.IcompanyCustomer companyCustomer)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var newCompanyCustomer = new tblCompanyCustomer()
{
_address = companyCustomer.Address,
active = companyCustomer.Active,
altPhoneNo = companyCustomer.AltPhoneNo,
companyContactPerson = companyCustomer.ContactPerson,
companyCustomersNo = companyCustomer.CompanyCustomersNo,
companyName = companyCustomer.Name,
cvrNo = companyCustomer.CvrNo,
email = companyCustomer.Email,
phoneNo = companyCustomer.PhoneNo,
postNo = companyCustomer.PostNo.Id,
};
dbContext.tblCompanyCustomers.InsertOnSubmit(newCompanyCustomer);
dbContext.SubmitChanges();
}
}
public void Add(Interface.Idepartment department)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
tblDepartment newDepartment = new tblDepartment
{
_address = department.Address,
active = department.Active,
altPhoneNo = department.AltPhoneNo,
companyName = department.CompanyName,
cvrNo = department.CvrNo,
department = department.Deparment,
departmentHeadNo = department.DeparmentHead.WorkNo,
email = department.Email,
phoneNo = department.PhoneNo,
postNo = department.PostNo.Id
};
dbContext.tblDepartments.InsertOnSubmit(newDepartment);
dbContext.SubmitChanges();
}
}
public void Add(Interface.IcompanyOrder companyOrder)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var newCompanyOrder = new tblCompanyOrder()
{
createBy = companyOrder.CreateBy.WorkNo,
createdDate = companyOrder.CreateDate,
customer = companyOrder.Customer.CompanyCustomersNo,
dateSendBill = companyOrder.DateSendBill,
daysToPaid = companyOrder.DaysToPaid,
descriptionTask = companyOrder.DescriptionTask,
hoursUse = Convert.ToDecimal(companyOrder.HoutsUse),
paid = companyOrder.Paid,
paidHour = Convert.ToDecimal(companyOrder.PaidHour),
paidToACC = companyOrder.PaidToAcc,
taskDate = companyOrder.TaskDate,
};
dbContext.tblCompanyOrders.InsertOnSubmit(newCompanyOrder);
dbContext.SubmitChanges();
}
}
public void Delete(Interface.IpostNo postNumber)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
tblPostNo postNo = dbContext.tblPostNos.SingleOrDefault(x => x.ID == postNumber.Id);
dbContext.tblPostNos.DeleteOnSubmit(postNo);
var deleteItem = new StringBuilder();
deleteItem.Append("[tblPostNo] { ");
deleteItem.Append("ID = " + postNo.ID + ", ");
deleteItem.Append("postNo = " + postNo.postNo + ", ");
deleteItem.Append("city = " + postNo.city);
deleteItem.Append("} ");
tblDeleteItem newDelete = new tblDeleteItem
{
itemInfo = deleteItem.ToString(),
deleteDate = DateTime.Now,
restored = false
};
dbContext.SubmitChanges();
}
}
public void Update(Interface.IcompanyOrder companyOrder)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var companyOrderUpdateing = dbContext.tblCompanyOrders.SingleOrDefault(
x => x.invoiceNo == companyOrder.InvoiceNo);
if (companyOrder.CreateBy != null)
{
companyOrderUpdateing.createBy = companyOrder.CreateBy.WorkNo;
}
if (companyOrder.CreateDate != new DateTime())
{
companyOrderUpdateing.createdDate = companyOrder.CreateDate;
}
if (companyOrder.Customer != null)
{
companyOrderUpdateing.customer = companyOrder.Customer.CompanyCustomersNo;
}
if (companyOrder.DateSendBill != null)
{
if (companyOrder.DateSendBill != new DateTime())
{
companyOrderUpdateing.dateSendBill = companyOrder.DateSendBill;
}
}
if (companyOrder.DaysToPaid != -1)
{
companyOrderUpdateing.daysToPaid = companyOrder.DaysToPaid;
}
if (companyOrder.DescriptionTask != string.Empty && companyOrder.DescriptionTask != null)
{
companyOrderUpdateing.descriptionTask = companyOrder.DescriptionTask;
}
if (companyOrder.HoutsUse != -1)
{
companyOrderUpdateing.hoursUse = Convert.ToDecimal(companyOrder.HoutsUse);
}
companyOrderUpdateing.paid = companyOrder.Paid;
if (companyOrder.PaidHour != -1)
{
companyOrderUpdateing.paidHour = Convert.ToDecimal(companyOrder.PaidHour);
}
if (companyOrder.PaidToAcc != -1)
{
companyOrderUpdateing.paidToACC = companyOrder.PaidToAcc;
}
if (companyOrder.TaskDate != new DateTime())
{
companyOrderUpdateing.taskDate = companyOrder.TaskDate;
}
dbContext.SubmitChanges();
}
}
public void Update(Interface.IprivetOrder privetOrder)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var privetOrderUpteing = dbContext.tblPrivetOrders.SingleOrDefault(
x => x.invoiceNo == privetOrder.InvoiceNo);
if (privetOrder.CreateBy != null)
{
privetOrderUpteing.createBy = privetOrder.CreateBy.WorkNo;
}
if (privetOrder.CreateDate != new DateTime())
{
privetOrderUpteing.createdDate = privetOrder.CreateDate;
}
if (privetOrder.Customer != null)
{
privetOrderUpteing.customers = privetOrder.Customer.PrivateCustomersNo;
}
if (privetOrder.DateSendBill != new DateTime())
{
privetOrderUpteing.dateSendBill = privetOrder.DateSendBill;
}
if (privetOrder.DaysToPaid != -1)
{
privetOrderUpteing.daysToPaid = privetOrder.DaysToPaid;
}
if (privetOrder.PaidToAcc != -1)
{
privetOrderUpteing.paidToACC = privetOrder.PaidToAcc;
}
if (privetOrder.DescriptionTask != null)
{
privetOrderUpteing.descriptionTask = privetOrder.DescriptionTask;
}
if (privetOrder.HourUse != -1)
{
privetOrderUpteing.hoursUse = Convert.ToDecimal(privetOrder.HourUse);
}
privetOrderUpteing.paid = privetOrder.Paid;
if (privetOrder.PaidHour != -1)
{
privetOrderUpteing.paidHour = Convert.ToDecimal(privetOrder.PaidHour);
}
if (privetOrder.TaskDate != new DateTime())
{
privetOrderUpteing.taskDate = privetOrder.TaskDate;
}
dbContext.SubmitChanges();
}
}
