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)); }