public int curddata(MCurdPackedData receive)
{
int result = 0;
try
{
DBParameterCollection paramcollection = new DBParameterCollection();
paramcollection.Add(new DBParameter("@CurdPackedDataId", receive.CurdPackedDataId));
paramcollection.Add(new DBParameter("@RMRId", receive.RMRId));
paramcollection.Add(new DBParameter("@CurdShiftId", receive.CurdShiftId));
paramcollection.Add(new DBParameter("@CurdPackedDate", receive.CurdPackedDate));
paramcollection.Add(new DBParameter("@PackingOperatorName", receive.PackingOperatorName));
paramcollection.Add(new DBParameter("@ReceivedBy", receive.ReceivedBy));
paramcollection.Add(new DBParameter("@CurdCupQty", receive.CurdCupQty));
paramcollection.Add(new DBParameter("@Curd500MLQty", receive.Curd500MLQty));
paramcollection.Add(new DBParameter("@Curd450MLQty", receive.Curd450MLQty));
paramcollection.Add(new DBParameter("@ButterMilk200ML", receive.ButterMilk200ML));
paramcollection.Add(new DBParameter("@TotalQtyOfCurd", receive.TotalQtyOfCurd));
paramcollection.Add(new DBParameter("@ColdRoomNo", receive.ColdRoomNo));
paramcollection.Add(new DBParameter("@flag", receive.flag));
result = _DBHelper.ExecuteNonQuery("prod_spCurdPackedDataDetails", paramcollection, CommandType.StoredProcedure);
}
catch (Exception EX)
{
string MSG = EX.ToString();
}
return(result);
}
public int curddata(MCurdPackedData receive)
{
dacurddata = new DACurdPackedData();
int Result = 0;
try
{
Result = dacurddata.curddata(receive);
}
catch (Exception)
{
throw;
}
return(Result);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
{
mcurd = new MCurdPackedData();
bcurd = new BCurdPackedData();
int Result = 0;
mcurd.CurdPackedDataId = 0;
mcurd.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
mcurd.CurdPackedDate = Convert.ToDateTime(txtDate.Text.ToString());
mcurd.CurdShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
mcurd.PackingOperatorName = txtPackingOperatorName.Text;
mcurd.ReceivedBy = txtReceivedBy.Text;
mcurd.CurdCupQty = string.IsNullOrEmpty(txtCurdCupQty.Text) ? 0 : Convert.ToDouble(txtCurdCupQty.Text);
mcurd.Curd500MLQty = string.IsNullOrEmpty(txtCurd500mlQty.Text) ? 0 : Convert.ToDouble(txtCurd500mlQty.Text);
mcurd.Curd450MLQty = string.IsNullOrEmpty(txt450mlQty.Text) ? 0 : Convert.ToDouble(txt450mlQty.Text);
mcurd.ButterMilk200ML = string.IsNullOrEmpty(txtButterMilk200ml.Text) ? 0 : Convert.ToDouble(txtButterMilk200ml.Text);
mcurd.TotalQtyOfCurd = string.IsNullOrEmpty(txtTotalOfCurd.Text) ? 0 : Convert.ToDouble(txtTotalOfCurd.Text);
mcurd.ColdRoomNo = txtColdRoomNo.Text;
mcurd.flag = "Update";
Result = bcurd.curddata(mcurd);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Curd Packed Data Update Successfully";
pnlError.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
}
}
