//
public int filmdata(MFilmData receive)
{
int result = 0;
try
{
DBParameterCollection paramcollection = new DBParameterCollection();
paramcollection.Add(new DBParameter("@RMRId", receive.RMRId));
paramcollection.Add(new DBParameter("@FilmDataId", receive.FilmDataId));
paramcollection.Add(new DBParameter("@FilmDate", receive.FilmDate));
paramcollection.Add(new DBParameter("@ShiftId", receive.ShiftId));
paramcollection.Add(new DBParameter("@Product", receive.Product));
paramcollection.Add(new DBParameter("@CommodityWise", receive.CommodityWise));
paramcollection.Add(new DBParameter("@OpeningStock", receive.OpeningStock));
paramcollection.Add(new DBParameter("@ReceivedQty", receive.ReceivedQty));
paramcollection.Add(new DBParameter("@CalculateConsumedQty", receive.CalculateConsumedQty));
paramcollection.Add(new DBParameter("@Wastage", receive.Wastage));
paramcollection.Add(new DBParameter("@ClosingStock", receive.ClosingStock));
paramcollection.Add(new DBParameter("@MilkType", receive.MilkType));
paramcollection.Add(new DBParameter("@FilmDetailsStatusId", receive.FilmDetailsStatusId));
paramcollection.Add(new DBParameter("@flag", receive.flag));
result = _DBHelper.ExecuteNonQuery("sp_Prod_FilmDataDetails", paramcollection, CommandType.StoredProcedure);
}
catch (Exception EX)
{
String MSG = EX.ToString();
}
return(result);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
{
mdata = new MFilmData();
bdata = new BFilmData();
int Result = 0;
mdata.FilmDataId = 0;
mdata.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
mdata.FilmDate = Convert.ToDateTime(txtDate.Text.ToString());
mdata.ShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
mdata.Product = string.IsNullOrEmpty(txtProduct.Text) ? string.Empty : txtProduct.Text;
mdata.CommodityWise = string.IsNullOrEmpty(txtCommodityWise.Text) ? string.Empty : (txtCommodityWise.Text);
mdata.OpeningStock = string.IsNullOrEmpty(txtOpeningStock.Text) ? 0 : Convert.ToDouble(txtOpeningStock.Text);
mdata.ReceivedQty = string.IsNullOrEmpty(txtReceivedQty.Text) ? 0 : Convert.ToDouble(txtReceivedQty.Text);
mdata.CalculateConsumedQty = string.IsNullOrEmpty(txtCalculateConsumedQty.Text) ? 0 : Convert.ToDouble(txtCalculateConsumedQty.Text);
mdata.Wastage = string.IsNullOrEmpty(txtWastage.Text) ? 0 : Convert.ToDouble(txtWastage.Text);
mdata.ClosingStock = string.IsNullOrEmpty(txtClosingStock.Text) ? 0 : Convert.ToDouble(txtClosingStock.Text);
mdata.MilkType = string.IsNullOrEmpty(txtMilkType.Text)? string.Empty : txtMilkType.Text;
mdata.FilmDetailsStatusId = Convert.ToInt32(dpFilmDetailsStatusId.SelectedItem.Value);
mdata.flag = "Insert";
Result = bdata.filmdata(mdata);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true);
//string dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
//GetFilmDetails(dates);
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
GetFilmDetails(R);
uprouteList.Update();
lblSuccess.Text = "Film Data Added Successfully";
pnlError.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
//return Result;
}
}
public int filmdata(MFilmData receive)
{
dadata = new DAFilmData();
int Result = 0;
try
{
Result = dadata.filmdata(receive);
}
catch (Exception)
{
throw;
}
return(Result);
}
