protected void btnConsSubmit_Click(object sender, EventArgs e) { deliveryEntity deliveryEntityObj = new deliveryEntity(); deliveryEntityObj.delTrackId_ = txtTrckId.Text.Trim().ToUpper(); //deliveryEntityObj.delSourceBranchId_ = txtDelSrcBrId.Text.Trim().ToUpper(); //deliveryEntityObj.delSourceBranchName_ = txtDelSrcBrName.Text.Trim().ToUpper(); deliveryEntityObj.delDateOfDel_ = Convert.ToDateTime(txtDelDateOfDel.Text.Trim()); deliveryEntityObj.delCurrentBranchId_ = txtCrBrId.Text.Trim().ToUpper(); deliveryEntityObj.delNextBranchId_ = txtNxtBrId.Text.Trim().ToUpper(); deliveryEntityObj.delDateOfRec_ = Convert.ToDateTime(txtDelDateOfRec.Text.Trim()); //deliveryEntityObj.delDestnBranchId_ = txtDelDestBrId.Text.Trim().ToUpper(); //deliveryEntityObj.delDestnBranchName_ = txtDelDestBrName.Text.Trim().ToUpper(); deliveryEntityObj.delExpDateOfDel_ = Convert.ToDateTime(txtExpDelDateOfDel.Text.Trim()); deliveryEntityObj.delCurrentLocation_ = txtDelCrLoc.Text.Trim(); deliveryEntityObj.delEmpMail_ = empEmail; if (String.Equals(currentBranch, destBranch)) { deliveryEntityObj.delStatus_ = Convert.ToBoolean(true); consignmentEntity consignmentEntityObj = new consignmentEntity(); consignmentEntityObj.consDelStatus_ = deliveryEntityObj.delStatus_; string trackId = txtTrckId.Text.Trim().ToUpper(); consDelStatusBAL consDelStatusBALObj = new consDelStatusBAL(); consDelStatusBALObj.consDelStatusBALF(consignmentEntityObj, trackId); } empEditDeliveryBAL empEditDeliveryBALObj = new empEditDeliveryBAL(); empEditDeliveryBALObj.empEditDeliveryBALF(deliveryEntityObj); Response.Redirect("viewDelivery.aspx"); }
public void addDeliveryDALF(deliveryEntity deliveryEntityObj) { string CS = ConfigurationManager.ConnectionStrings["PTS_DatabaseConnectionString1"].ConnectionString; using (SqlConnection conObj = new SqlConnection(CS)) { SqlCommand cmdObj = new SqlCommand("addDelivery", conObj); cmdObj.CommandType = CommandType.StoredProcedure; //cmdObj.Parameters.AddWithValue("@delID", deliveryEntityObj.delID_); cmdObj.Parameters.AddWithValue("@delTrackId", deliveryEntityObj.delTrackId_); cmdObj.Parameters.AddWithValue("@delSourceBranchId", deliveryEntityObj.delSourceBranchId_); cmdObj.Parameters.AddWithValue("@delSourceBranchName", deliveryEntityObj.delSourceBranchName_); cmdObj.Parameters.AddWithValue("@delEmpMail", deliveryEntityObj.delEmpMail_); cmdObj.Parameters.AddWithValue("@delDateOfDel", deliveryEntityObj.delDateOfDel_); cmdObj.Parameters.AddWithValue("@delCurrentBranchId", deliveryEntityObj.delCurrentBranchId_); cmdObj.Parameters.AddWithValue("@delNextBranchId", deliveryEntityObj.delNextBranchId_); cmdObj.Parameters.AddWithValue("@delDateOfRec", deliveryEntityObj.delDateOfRec_); cmdObj.Parameters.AddWithValue("@delDestnBranchId", deliveryEntityObj.delDestnBranchId_); cmdObj.Parameters.AddWithValue("@delDestnBranchName", deliveryEntityObj.delDestnBranchName_); cmdObj.Parameters.AddWithValue("@delExpDateOfDel", deliveryEntityObj.delExpDateOfDel_); cmdObj.Parameters.AddWithValue("@delCurrentLocation", deliveryEntityObj.delCurrentLocation_); cmdObj.Parameters.AddWithValue("@delStatus", deliveryEntityObj.delStatus_); conObj.Open(); cmdObj.ExecuteNonQuery(); } }
protected void btnConsSubmit_Click(object sender, EventArgs e) { deliveryEntity deliveryEntityObj = new deliveryEntity(); deliveryEntityObj.delTrackId_ = txtTrckId.Text.Trim().ToUpper(); deliveryEntityObj.delSourceBranchId_ = txtDelSrcBrId.Text.Trim().ToUpper(); deliveryEntityObj.delSourceBranchName_ = txtDelSrcBrName.Text.Trim().ToUpper(); deliveryEntityObj.delDateOfDel_ = Convert.ToDateTime(txtDelDateOfDel.Text.Trim()); deliveryEntityObj.delCurrentBranchId_ = txtCrBrId.Text.Trim().ToUpper(); deliveryEntityObj.delNextBranchId_ = txtNxtBrId.Text.Trim().ToUpper(); deliveryEntityObj.delDateOfRec_ = Convert.ToDateTime(txtDelDateOfRec.Text.Trim()); deliveryEntityObj.delDestnBranchId_ = txtDelDestBrId.Text.Trim().ToUpper(); deliveryEntityObj.delDestnBranchName_ = txtDelDestBrName.Text.Trim().ToUpper(); deliveryEntityObj.delExpDateOfDel_ = Convert.ToDateTime(txtExpDelDateOfDel.Text.Trim()); deliveryEntityObj.delCurrentLocation_ = txtDelCrLoc.Text.Trim(); deliveryEntityObj.delEmpMail_ = empEmail; //deliveryEntityObj.delStatus_ = Convert.ToBoolean(1); addDeliveryBAL addDeliveryBALObj = new addDeliveryBAL(); addDeliveryBALObj.addDeliveryBALF(deliveryEntityObj); }
public void addDeliveryBALF(deliveryEntity deliveryEntityObj) { addDeliveryDAL addDeliveryDALObj = new addDeliveryDAL(); addDeliveryDALObj.addDeliveryDALF(deliveryEntityObj); }
public void empEditDeliveryBALF(deliveryEntity deliveryEntityObj) { empEditDeliveryDAL empEditDeliveryDALObj = new empEditDeliveryDAL(); empEditDeliveryDALObj.empEditDeliveryDALF(deliveryEntityObj); }