コード例 #1
0
    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");
    }
コード例 #2
0
        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();
            }
        }
コード例 #3
0
    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);
    }
コード例 #4
0
        public void addDeliveryBALF(deliveryEntity deliveryEntityObj)
        {
            addDeliveryDAL addDeliveryDALObj = new addDeliveryDAL();

            addDeliveryDALObj.addDeliveryDALF(deliveryEntityObj);
        }
コード例 #5
0
        public void empEditDeliveryBALF(deliveryEntity deliveryEntityObj)
        {
            empEditDeliveryDAL empEditDeliveryDALObj = new empEditDeliveryDAL();

            empEditDeliveryDALObj.empEditDeliveryDALF(deliveryEntityObj);
        }