public void addDispatchDALF(dispatchEntity dispatchEntityObj)
{
string CS = ConfigurationManager.ConnectionStrings["PTS_DatabaseConnectionString1"].ConnectionString;
using (SqlConnection conObj = new SqlConnection(CS))
{
SqlCommand cmdObj = new SqlCommand("addDispatch", conObj);
cmdObj.CommandType = CommandType.StoredProcedure;
//cmdObj.Parameters.AddWithValue("@disId", dispatchEntityObj.disId_);
cmdObj.Parameters.AddWithValue("@disTrackId", dispatchEntityObj.disTrackId_);
cmdObj.Parameters.AddWithValue("@disEmpId", dispatchEntityObj.disEmpId_);
cmdObj.Parameters.AddWithValue("@disEmpName", dispatchEntityObj.disEmpName_);
cmdObj.Parameters.AddWithValue("@disEmpMobile", dispatchEntityObj.disEmpMobile_);
cmdObj.Parameters.AddWithValue("@disBranchId", dispatchEntityObj.disBranchId_);
cmdObj.Parameters.AddWithValue("@disBranchName", dispatchEntityObj.disBranchName_);
cmdObj.Parameters.AddWithValue("@disShipperName", dispatchEntityObj.disShipperName_);
cmdObj.Parameters.AddWithValue("@disShipperPhone", dispatchEntityObj.disShipperPhone_);
cmdObj.Parameters.AddWithValue("@disShipperMail", dispatchEntityObj.disShipperMail_);
cmdObj.Parameters.AddWithValue("@disShipperAddress", dispatchEntityObj.disShipperAddress_);
cmdObj.Parameters.AddWithValue("@disReceiverName", dispatchEntityObj.disReceiverName_);
cmdObj.Parameters.AddWithValue("@disReceiverPhone", dispatchEntityObj.disReceiverPhone_);
cmdObj.Parameters.AddWithValue("@disReceiverMail", dispatchEntityObj.disReceiverMail_);
cmdObj.Parameters.AddWithValue("@disReceiverAddress", dispatchEntityObj.disReceiverAddress_);
cmdObj.Parameters.AddWithValue("@disDateOfDis", dispatchEntityObj.disDateOfDis_);
cmdObj.Parameters.AddWithValue("@disBookedBy", dispatchEntityObj.disBookedBy_);
cmdObj.Parameters.AddWithValue("@disStatus", dispatchEntityObj.disStatus_);
conObj.Open();
cmdObj.ExecuteNonQuery();
}
}
public void addDispatchBALF(dispatchEntity dispatchEntityObj)
{
addDispatchDAL addDispatchDALObj = new addDispatchDAL();
addDispatchDALObj.addDispatchDALF(dispatchEntityObj);
}
