protected void updateFoodItemDetails()
{
bool result = FOODITEM_TRANSDETAILManager.DeleteFOODITEM_TRANSDETAILByTID(Convert.ToInt32(hfFOODTRANSID.Value.ToString()));
//if (result == true)
{
FOODITEM_TRANSDETAIL fOODITEM_TRANSDETAIL = new FOODITEM_TRANSDETAIL();
for (int i = 0; i < gvFoodTransactionItemRelation.Rows.Count; i++)
{
Label lblfID = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblfID");
Label lblfRATE = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblfRATE");
Label lblfQTY = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblfQTY");
Label lblCUSTID = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblCUSTID");
Label lblLOCATIONID = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblLOCATIONID");
Label lblRECEIVERID = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblRECEIVERID");
fOODITEM_TRANSDETAIL.TID = int.Parse(hfFOODTRANSID.Value.ToString());
fOODITEM_TRANSDETAIL.FID = Int32.Parse(lblfID.Text);
fOODITEM_TRANSDETAIL.FRATE = decimal.Parse(lblfRATE.Text);
fOODITEM_TRANSDETAIL.FQTY = Int32.Parse(lblfQTY.Text);
fOODITEM_TRANSDETAIL.CREATEDON = DateTime.Now;
fOODITEM_TRANSDETAIL.CREATEDBY = 1;
fOODITEM_TRANSDETAIL.UPDATEDON = DateTime.Now;
fOODITEM_TRANSDETAIL.UPDATEDBY = 1;
int resutl = FOODITEM_TRANSDETAILManager.InsertFOODITEM_TRANSDETAIL(fOODITEM_TRANSDETAIL);
}
}
}
public static FOODITEM_TRANSDETAIL GetFOODITEM_TRANSDETAILByID(int id)
{
FOODITEM_TRANSDETAIL fOODITEM_TRANSDETAIL = new FOODITEM_TRANSDETAIL();
SqlFOODITEM_TRANSDETAILProvider sqlFOODITEM_TRANSDETAILProvider = new SqlFOODITEM_TRANSDETAILProvider();
fOODITEM_TRANSDETAIL = sqlFOODITEM_TRANSDETAILProvider.GetFOODITEM_TRANSDETAILByID(id);
return(fOODITEM_TRANSDETAIL);
}
public bool UpdateFOODITEM_TRANSDETAIL(FOODITEM_TRANSDETAIL fOODITEM_TRANSDETAIL)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateFOODITEM_TRANSDETAIL", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FOODITEM_TRANSDETAILID", SqlDbType.Int).Value = fOODITEM_TRANSDETAIL.FOODITEM_TRANSDETAILID;
cmd.Parameters.Add("@TID", SqlDbType.Int).Value = fOODITEM_TRANSDETAIL.TID;
cmd.Parameters.Add("@FID", SqlDbType.Int).Value = fOODITEM_TRANSDETAIL.FID;
cmd.Parameters.Add("@FRATE", SqlDbType.Decimal).Value = fOODITEM_TRANSDETAIL.FRATE;
cmd.Parameters.Add("@FQTY", SqlDbType.Int).Value = fOODITEM_TRANSDETAIL.FQTY;
cmd.Parameters.Add("@CREATEDON", SqlDbType.DateTime).Value = fOODITEM_TRANSDETAIL.CREATEDON;
cmd.Parameters.Add("@CREATEDBY", SqlDbType.Int).Value = fOODITEM_TRANSDETAIL.CREATEDBY;
cmd.Parameters.Add("@UPDATEDON", SqlDbType.DateTime).Value = fOODITEM_TRANSDETAIL.UPDATEDON;
cmd.Parameters.Add("@UPDATEDBY", SqlDbType.Int).Value = fOODITEM_TRANSDETAIL.UPDATEDBY;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public FOODITEM_TRANSDETAIL GetFOODITEM_TRANSDETAILFromReader(IDataReader reader)
{
try
{
FOODITEM_TRANSDETAIL fOODITEM_TRANSDETAIL = new FOODITEM_TRANSDETAIL
(
(int)reader["FOODITEM_TRANSDETAILID"],
(int)reader["TID"],
(int)reader["FID"],
(decimal)reader["FRATE"],
(int)reader["FQTY"],
(DateTime)reader["CREATEDON"],
(int)reader["CREATEDBY"],
(DateTime)reader["UPDATEDON"],
(int)reader["UPDATEDBY"]
);
return(fOODITEM_TRANSDETAIL);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateFOODITEM_TRANSDETAIL(FOODITEM_TRANSDETAIL fOODITEM_TRANSDETAIL)
{
SqlFOODITEM_TRANSDETAILProvider sqlFOODITEM_TRANSDETAILProvider = new SqlFOODITEM_TRANSDETAILProvider();
return(sqlFOODITEM_TRANSDETAILProvider.UpdateFOODITEM_TRANSDETAIL(fOODITEM_TRANSDETAIL));
}
public static int InsertFOODITEM_TRANSDETAIL(FOODITEM_TRANSDETAIL fOODITEM_TRANSDETAIL)
{
SqlFOODITEM_TRANSDETAILProvider sqlFOODITEM_TRANSDETAILProvider = new SqlFOODITEM_TRANSDETAILProvider();
return(sqlFOODITEM_TRANSDETAILProvider.InsertFOODITEM_TRANSDETAIL(fOODITEM_TRANSDETAIL));
}
protected void btnSaveTransaction_Click(object sender, EventArgs e)
{
try
{
if (Session["sessionFOODITEM_TRANSMASTERDETAIL"] != null)
{
AGENT aGENT = (AGENT)Session["aGENT"];
DateTime nullDate = DateTime.Parse(ConfigurationManager.AppSettings["NULL_DATE"].ToString());
List <FOODITEM_TRANSMASTERDETAIL> fOODITEM_TRANSMASTERDETAIL_Ori = new List <FOODITEM_TRANSMASTERDETAIL>();
fOODITEM_TRANSMASTERDETAIL_Ori = (List <FOODITEM_TRANSMASTERDETAIL>)Session["sessionFOODITEM_TRANSMASTERDETAIL"];
List <FOODITEM_TRANSMASTERDETAIL> fOODITEM_TRANSMASTERDETAIL_Distinct = new List <FOODITEM_TRANSMASTERDETAIL>();
int count = 0;
for (int i = 0; i < fOODITEM_TRANSMASTERDETAIL_Ori.Count; i++)
{
count = fOODITEM_TRANSMASTERDETAIL_Distinct.FindAll(x => x.CUSTID == fOODITEM_TRANSMASTERDETAIL_Ori[i].CUSTID && x.LOCATIONID == fOODITEM_TRANSMASTERDETAIL_Ori[i].LOCATIONID && x.RECEIVERID == fOODITEM_TRANSMASTERDETAIL_Ori[i].RECEIVERID).Count;
if (count == 0)
{
fOODITEM_TRANSMASTERDETAIL_Distinct.Add(fOODITEM_TRANSMASTERDETAIL_Ori[i]);
}
}
string refCode = string.Empty;
for (int j = 0; j < fOODITEM_TRANSMASTERDETAIL_Distinct.Count; j++)
{
#region FoodItemTransMaster
FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
fOODITEM_TRANSMASTER.TDATE = DateTime.Now;
fOODITEM_TRANSMASTER.CID = fOODITEM_TRANSMASTERDETAIL_Distinct[j].CUSTID;
fOODITEM_TRANSMASTER.LID = int.Parse(Session["snFoodlocationID"].ToString());
fOODITEM_TRANSMASTER.AID = aGENT.AGENTID;
//fOODITEM_TRANSMASTER.TOTALAMT = fOODITEM_TRANSMASTERDETAIL_Distinct[j].TOTALAMT;
fOODITEM_TRANSMASTER.TOTALAMT = decimal.Parse(lblTotalAmount.Text);
fOODITEM_TRANSMASTER.TRANSSTATUS = "PENDING";
fOODITEM_TRANSMASTER.REFCODE = txtReferenceCode.Text;
fOODITEM_TRANSMASTER.RECID = fOODITEM_TRANSMASTERDETAIL_Distinct[j].RECEIVERID;
fOODITEM_TRANSMASTER.RECDATE = nullDate;
fOODITEM_TRANSMASTER.STOREID = 1;
fOODITEM_TRANSMASTER.CREATEDON = DateTime.Now;
fOODITEM_TRANSMASTER.CREATEDBY = aGENT.AGENTID;
fOODITEM_TRANSMASTER.UPDATEDON = DateTime.Now;
fOODITEM_TRANSMASTER.UPDATEDBY = aGENT.AGENTID;
int resutlfOODITEM_TRANSMASTER = FOODITEM_TRANSMASTERManager.InsertFOODITEM_TRANSMASTER(fOODITEM_TRANSMASTER);
#endregion
FOODITEM_TRANSDETAIL fOODITEM_TRANSDETAIL = new FOODITEM_TRANSDETAIL();
for (int i = 0; i < gvFoodTransactionItemRelation.Rows.Count; i++)
{
Label lblfID = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblfID");
Label lblfRATE = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblfRATE");
Label lblfQTY = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblfQTY");
Label lblCUSTID = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblCUSTID");
Label lblLOCATIONID = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblLOCATIONID");
Label lblRECEIVERID = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblRECEIVERID");
if (int.Parse(lblCUSTID.Text) == fOODITEM_TRANSMASTERDETAIL_Distinct[j].CUSTID && int.Parse(lblLOCATIONID.Text) == fOODITEM_TRANSMASTERDETAIL_Distinct[j].LOCATIONID && int.Parse(lblRECEIVERID.Text) == fOODITEM_TRANSMASTERDETAIL_Distinct[j].RECEIVERID)
{
fOODITEM_TRANSDETAIL.TID = resutlfOODITEM_TRANSMASTER;
fOODITEM_TRANSDETAIL.FID = Int32.Parse(lblfID.Text);
fOODITEM_TRANSDETAIL.FRATE = decimal.Parse(lblfRATE.Text);
fOODITEM_TRANSDETAIL.FQTY = Int32.Parse(lblfQTY.Text);
fOODITEM_TRANSDETAIL.CREATEDON = DateTime.Now;
fOODITEM_TRANSDETAIL.CREATEDBY = 1;
fOODITEM_TRANSDETAIL.UPDATEDON = DateTime.Now;
fOODITEM_TRANSDETAIL.UPDATEDBY = 1;
int resutl = FOODITEM_TRANSDETAILManager.InsertFOODITEM_TRANSDETAIL(fOODITEM_TRANSDETAIL);
}
}
lblReferenceCODE.Text = FOODITEM_TRANSMASTERManager.GetFOODITEM_TRANSMASTERByID(resutlfOODITEM_TRANSMASTER).REFCODE.ToString();// +"<br/>" + refCode.ToString();
refCode = lblReferenceCODE.Text;
}
//lblmessage.Text = resutlfOODITEM_TRANSMASTER.ToString();
lblmessage.Text = "Food Transfer Successfully.. ";
lblText.Text = "Reference CODE: ";
//lblReferenceCODE.Text= FOODITEM_TRANSMASTERManager.GetFOODITEM_TRANSMASTERByID(resutlfOODITEM_TRANSMASTER).REFCODE ;
}
}
catch (Exception ex)
{
lblmessage.Text = ex.ToString();
}
}
