public void addReceiverDALF(receiverEntity receiverEntityObj)
        {
            using (SqlConnection conObj = new SqlConnection(CS))
            {
                SqlCommand cmdObj = new SqlCommand("addReceiver", conObj);
                cmdObj.CommandType = CommandType.StoredProcedure;

                cmdObj.Parameters.AddWithValue("@recTrackId", receiverEntityObj.recTrackId_);
                cmdObj.Parameters.AddWithValue("@recReceiverName", receiverEntityObj.recReceiverName_);
                cmdObj.Parameters.AddWithValue("@recReceiverPhone", receiverEntityObj.recReceiverPhone_);
                cmdObj.Parameters.AddWithValue("@recSourceBranchId", receiverEntityObj.recSourceBranchId_);
                cmdObj.Parameters.AddWithValue("@recDestBranchId", receiverEntityObj.recDestBranchId_);
                cmdObj.Parameters.AddWithValue("@recMaterialDesc", receiverEntityObj.recMaterialDesc_);
                cmdObj.Parameters.AddWithValue("@recTotalItems", receiverEntityObj.recTotalItems_);
                cmdObj.Parameters.AddWithValue("@recDateOfRec", receiverEntityObj.recDateOfRec_);
                cmdObj.Parameters.AddWithValue("@recStatus", receiverEntityObj.recStatus_);

                conObj.Open();
                cmdObj.ExecuteNonQuery();
            }
        }
Beispiel #2
0
        public void addReceiverBALF(receiverEntity receiverEntityObj)
        {
            addReceiverDAL addReceiverDALObj = new addReceiverDAL();

            addReceiverDALObj.addReceiverDALF(receiverEntityObj);
        }