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 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();
}
}
public Interface.IprivetOrder Find(int id)
{
Interface.IprivetOrder privetOrder = null;
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var privetOrderFound = dbContext.tblPrivetOrders.SingleOrDefault(
x => x.invoiceNo == id);
privetOrder = new InterfaceAdaptor.PrivetOrder()
{
CreateBy = new InterfaceAdaptor.Worker()
{
Active = (bool)privetOrderFound.tblWorker.active,
Address = privetOrderFound.tblWorker.homeAddress,
AltPhoneNo = privetOrderFound.tblWorker.altPhoneNo,
Email = privetOrderFound.tblWorker.email,
Name = privetOrderFound.tblWorker.name,
PhoneNo = privetOrderFound.tblWorker.phoneNo,
PostNo = new InterfaceAdaptor.PostNo()
{
City = privetOrderFound.tblWorker.tblPostNo.city,
Id = privetOrderFound.tblWorker.tblPostNo.ID,
PostNumber = privetOrderFound.tblWorker.tblPostNo.postNo
},
Surname = privetOrderFound.tblWorker.surname,
WorkerStatus = new InterfaceAdaptor.WorkerStatus()
{
StautsNo = privetOrderFound.tblWorker.tblWorkerStatus.statusNo,
Staus = privetOrderFound.tblWorker.tblWorkerStatus.status
},
WorkNo = privetOrderFound.tblWorker.workNo
},
CreateDate = (DateTime)privetOrderFound.createdDate,
Customer = new InterfaceAdaptor.PrivetCustomer()
{
Active = (bool)privetOrderFound.tblPrivateCustomer.active,
AltPhoneNo = privetOrderFound.tblPrivateCustomer.altPhoneNo,
Email = privetOrderFound.tblPrivateCustomer.email,
HomeAddress = privetOrderFound.tblPrivateCustomer.homeAddress,
Name = privetOrderFound.tblPrivateCustomer.name,
PhoneNo = privetOrderFound.tblPrivateCustomer.phoneNo,
PostNo = new InterfaceAdaptor.PostNo()
{
City = privetOrderFound.tblPrivateCustomer.tblPostNo.city,
Id = privetOrderFound.tblPrivateCustomer.tblPostNo.ID,
PostNumber = privetOrderFound.tblPrivateCustomer.tblPostNo.postNo
},
PrivateCustomersNo = privetOrderFound.tblPrivateCustomer.privateCustomersNo,
Surname = privetOrderFound.tblPrivateCustomer.surname
},
DateSendBill = privetOrderFound.dateSendBill,
DaysToPaid = (int)privetOrderFound.daysToPaid,
DescriptionTask = privetOrderFound.descriptionTask,
HourUse = Convert.ToDouble(privetOrderFound.hoursUse),
InvoiceNo = privetOrderFound.invoiceNo,
Paid = (bool)privetOrderFound.paid,
PaidHour = Convert.ToDouble(privetOrderFound.paidHour),
PaidToAcc = privetOrderFound.paidToACC,
TaskDate = privetOrderFound.taskDate,
};
}
return(privetOrder);
}
