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 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 Interface.IcompanyOrder Find(int id)
{
Interface.IcompanyOrder companyOrder = null;
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var companyOrderFound = dbContext.tblCompanyOrders.SingleOrDefault(
x => x.invoiceNo == id);
companyOrder = new InterfaceAdaptor.CompanyOrder()
{
CreateBy = new InterfaceAdaptor.Worker()
{
Active = (bool)companyOrderFound.tblWorker.active,
Address = companyOrderFound.tblWorker.homeAddress,
AltPhoneNo = companyOrderFound.tblWorker.altPhoneNo,
Email = companyOrderFound.tblWorker.email,
Name = companyOrderFound.tblWorker.name,
PhoneNo = companyOrderFound.tblWorker.phoneNo,
PostNo = new InterfaceAdaptor.PostNo()
{
City = companyOrderFound.tblWorker.tblPostNo.city,
Id = companyOrderFound.tblWorker.tblPostNo.ID,
PostNumber = companyOrderFound.tblWorker.tblPostNo.postNo
},
Surname = companyOrderFound.tblWorker.surname,
WorkerStatus = new InterfaceAdaptor.WorkerStatus()
{
Staus = companyOrderFound.tblWorker.tblWorkerStatus.status,
StautsNo = companyOrderFound.tblWorker.tblWorkerStatus.statusNo
},
WorkNo = companyOrderFound.tblWorker.workNo,
},
CreateDate = (DateTime)companyOrderFound.createdDate,
Customer = new InterfaceAdaptor.CompanyCustomer()
{
Active = (bool)companyOrderFound.tblCompanyCustomer.active,
Address = companyOrderFound.tblCompanyCustomer._address,
AltPhoneNo = companyOrderFound.tblCompanyCustomer.altPhoneNo,
CompanyCustomersNo = companyOrderFound.tblCompanyCustomer.companyCustomersNo,
ContactPerson = companyOrderFound.tblCompanyCustomer.companyContactPerson,
CvrNo = companyOrderFound.tblCompanyCustomer.cvrNo,
Email = companyOrderFound.tblCompanyCustomer.email,
Name = companyOrderFound.tblCompanyCustomer.companyName,
PhoneNo = companyOrderFound.tblCompanyCustomer.phoneNo,
PostNo = new InterfaceAdaptor.PostNo()
{
City = companyOrderFound.tblCompanyCustomer.tblPostNo.city,
Id = companyOrderFound.tblCompanyCustomer.tblPostNo.ID,
PostNumber = companyOrderFound.tblCompanyCustomer.tblPostNo.postNo
},
},
DateSendBill = companyOrderFound.dateSendBill,
DaysToPaid = (int)companyOrderFound.daysToPaid,
DescriptionTask = companyOrderFound.descriptionTask,
HoutsUse = (double)companyOrderFound.hoursUse,
InvoiceNo = companyOrderFound.invoiceNo,
Paid = (bool)companyOrderFound.paid,
PaidHour = (double)companyOrderFound.paidHour,
PaidToAcc = (int)companyOrderFound.paidToACC,
TaskDate = (DateTime)companyOrderFound.taskDate
};
}
return(companyOrder);
}
