protected void lnkCompleteOrder_OnCommand(object sender, CommandEventArgs e)
{
STG_ServiceWork stg_servWork = Session["stg_servWork"] as STG_ServiceWork;
ServiceWorkToBeDoneList workList = Session["workList"] as ServiceWorkToBeDoneList;
// create an invoice
Invoice newInvoice = new Invoice();
newInvoice.AccountID = Convert.ToInt32(lblAccountNumber.Text);
newInvoice.InvoiceDate = DateTime.Now.ToLocalTime();
newInvoice.CreatedBy = User.Identity.Name.ToString();
//add service work subtotal + invoicelineitems subtotal
double totalServiceWorkCharge = ServiceWork.CalculateTotalWorkCharge(workList);
double totalServiceWorkChargeTax = ServiceWork.CalculateTotalTax(totalServiceWorkCharge, taxPercentage);
newInvoice.SubTotal = totalServiceWorkCharge;
//add service work tax + invoicelineitem tax
newInvoice.TotalTaxCharged = totalServiceWorkChargeTax;
//
newInvoice.TotalAmount = (totalServiceWorkCharge + totalServiceWorkChargeTax);
newInvoice.InvoiceID = InvoiceManager.Save(newInvoice);
// save service work using stg_service work and invoice ID from invoice
ServiceWork sWork = new ServiceWork();
sWork.AccountID = stg_servWork.AccountID;
sWork.ServiceDate = stg_servWork.ServiceDate;
sWork.ServiceStartTime = stg_servWork.ServiceStartTime;
sWork.ServiceEndTime = stg_servWork.ServiceEndTime;
//sWork.ServiceStatus = stg_servWork.ServiceStatus;
sWork.Technician = ddlTechnician.SelectedValue.ToString();
sWork.InvoiceID = newInvoice.InvoiceID;
sWork.SubTotal = totalServiceWorkCharge;
sWork.TaxCharged = totalServiceWorkChargeTax;
sWork.ServiceWorkID = ServiceWorkManager.Save(sWork);
// save service work to be done using service work ID
foreach (ServiceWorkToBeDone sWorkToBeDone in workList)
{
sWorkToBeDone.ServiceWorkID = sWork.ServiceWorkID;
//save each work to be done in the DB
sWorkToBeDone.WorkToBeDoneID = ServiceWorkToBeDoneManager.Save(sWorkToBeDone);
}
//clear the session variables
PerformSessionCleanup();
}
public static int Save(ServiceWork servWork)
{
int result;
MyDBConnection myConn = new MyDBConnection();
SqlConnection conn = new SqlConnection();
try
{
conn = myConn.OpenDB();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.[InsertUpdateServiceWork]";
if (servWork.ServiceWorkID == -1)
{
cmd.Parameters.Add("@ServiceWorkID", SqlDbType.Int).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add("@ServiceWorkID", SqlDbType.Int).Value = servWork.ServiceWorkID;
}
cmd.Parameters.Add("@AccountID", SqlDbType.Int).Value = servWork.AccountID;
//cmd.Parameters.Add("@ServiceStatus", SqlDbType.VarChar).Value = servWork.ServiceStatus;
cmd.Parameters.Add("@ServiceDate", SqlDbType.DateTime).Value = servWork.ServiceDate;
cmd.Parameters.Add("@ServiceStartTime", SqlDbType.Time).Value = new TimeSpan(servWork.ServiceStartTime.Hour, servWork.ServiceStartTime.Minute, 0);
cmd.Parameters.Add("@ServiceEndTime", SqlDbType.Time).Value = new TimeSpan(servWork.ServiceEndTime.Hour, servWork.ServiceEndTime.Minute, 0);
cmd.Parameters.Add("@Technician", SqlDbType.VarChar).Value = servWork.Technician;
cmd.Parameters.Add("@InvoiceID", SqlDbType.Int).Value = servWork.InvoiceID;
cmd.Parameters.Add("@SubTotal", SqlDbType.Decimal).Value = servWork.SubTotal;
cmd.Parameters.Add("@TaxCharged", SqlDbType.Decimal).Value = servWork.TaxCharged;
cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = servWork.CreatedDate;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = servWork.ModifiedDate;
cmd.Parameters.Add("@CreatedBy", SqlDbType.VarChar).Value = servWork.CreatedBy;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.VarChar).Value = servWork.ModifiedBy;
DbParameter returnValue = cmd.CreateParameter();
returnValue.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(returnValue);
cmd.ExecuteNonQuery();
result = Convert.ToInt32(returnValue.Value);
cmd.Dispose();
}
finally
{
myConn.CloseDB(conn);
}
return(result);
}
public void should_disable_and_reenable_timer_when_polling_enabled()
{
ITimer timer = MockRepository.GenerateMock<ITimer>();
timer.GetMockRepository().Ordered();
ICommandQueue proc = MockRepository.GenerateStub<ICommandQueue>();
Statics.ShouldPollXenStore = true;
ServiceWork elapsed = new ServiceWork(timer, proc);
elapsed.Do();
timer.AssertWasCalled(x => x.Enabled = false);
timer.AssertWasCalled(x => x.Enabled = true);
}
public void should_disable_and_not_reenable_timer_when_polling_disabled()
{
ITimer timer = MockRepository.GenerateMock <ITimer>();
timer.GetMockRepository().Ordered();
ICommandQueue proc = MockRepository.GenerateStub <ICommandQueue>();
Statics.ShouldPollXenStore = false;
ServiceWork elapsed = new ServiceWork(timer, proc);
elapsed.Do();
timer.AssertWasCalled(x => x.Enabled = false);
timer.AssertWasNotCalled(x => x.Enabled = true);
}
private static ServiceWork FillDataRecord(IDataRecord dr)
{
ServiceWork servWork = new ServiceWork();
servWork.ServiceWorkID = dr.GetInt32(dr.GetOrdinal("serviceworkID"));
servWork.AccountID = dr.GetInt32(dr.GetOrdinal("AccountID"));
servWork.InvoiceID = dr.GetInt32(dr.GetOrdinal("invoiceID"));
//servWork.ServiceStatus = dr.GetString(dr.GetOrdinal("ServiceStatus"));
servWork.ServiceDate = dr.GetDateTime(dr.GetOrdinal("ServiceDate"));
//use dr.getvalue
servWork.ServiceStartTime = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("ServiceStartTime")).ToString()); // dr.GetValue(dr.GetOrdinal("ServiceStartTime")) ;//dr.GetDateTime(dr.GetOrdinal("ServiceStartTime")).ToShortTimeString();
servWork.ServiceEndTime = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("ServiceEndTime")).ToString()); //Convert.ToDateTime( dr.GetValue(dr.GetOrdinal("ServiceEndTime")).ToString()).ToShortTimeString().Replace(" ","");//dr.GetDateTime(dr.GetOrdinal("ServiceEndTime")).ToShortTimeString() ;
servWork.Technician = dr.GetString(dr.GetOrdinal("Technician"));
return(servWork);
}
public static int Save(ServiceWork servWork)
{
return(ServiceWorkDB.Save(servWork));
}
