protected void gvLocation_RowDataBound(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
HiddenField hfLocationID = (HiddenField)e.Row.FindControl("hfLocationID");
GridView gvTRANS = (GridView)e.Row.FindControl("gvTRANS");
List <FOODITEM_TRANSMASTER> fOODITEM_TRANSMASTER = new List <FOODITEM_TRANSMASTER>();
fOODITEM_TRANSMASTER = FOODITEM_TRANSMASTERManager.GetAllFOODITEM_TRANSMASTERsForReport(loadStatus(), getLocationIDs(), int.Parse(ddlAgent.SelectedValue), txtFromDate.Text, txtToDate.Text, int.Parse(txtMoney.Text == "" ? "0" : txtMoney.Text)).FindAll(x => x.LID == int.Parse(hfLocationID.Value));
foreach (FOODITEM_TRANSMASTER item in fOODITEM_TRANSMASTER)
{
if (hfIsLocation.Value == "1")
{
item.IsAmountVisible = false;
}
else
{
item.IsAmountVisible = true;
}
}
gvTRANS.DataSource = fOODITEM_TRANSMASTER;
gvTRANS.DataBind();
Label lblSubTotalSendingAmount = (Label)e.Row.FindControl("lblSubTotalSendingAmount");
lblSubTotalSendingAmount.Text = fOODITEM_TRANSMASTER.Sum(x => x.TOTALAMT).ToString();
if (hfIsLocation.Value == "1")
{
lblSubTotalSendingAmount.Visible = false;
}
}
}
protected void updateFoodItemMaster(string transStatus)
{
// FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
//fOODITEM_TRANSMASTER = FOODITEM_TRANSMASTERManager.GetFOODITEM_TRANSMASTERByID(Int32.Parse(Request.QueryString["fOODITEM_TRANSMASTERID"]));
AGENT aGENT = (AGENT)Session["aGENT"];
DateTime nullDate = DateTime.Parse(ConfigurationManager.AppSettings["NULL_DATE"].ToString());
FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
fOODITEM_TRANSMASTER = FOODITEM_TRANSMASTERManager.GetFOODITEM_TRANSMASTERByRefCode(hfReferenceCode.Value);
FOODITEM_TRANSMASTER tempFOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
tempFOODITEM_TRANSMASTER.FOODITEM_TRANSMASTERID = fOODITEM_TRANSMASTER.FOODITEM_TRANSMASTERID;
tempFOODITEM_TRANSMASTER.TDATE = fOODITEM_TRANSMASTER.TDATE;
tempFOODITEM_TRANSMASTER.CID = fOODITEM_TRANSMASTER.CID;
tempFOODITEM_TRANSMASTER.LID = fOODITEM_TRANSMASTER.LID;
tempFOODITEM_TRANSMASTER.AID = fOODITEM_TRANSMASTER.AID;
tempFOODITEM_TRANSMASTER.TOTALAMT = decimal.Parse(lblTotalAmount.Text);
if (transStatus == "SAME")
{
tempFOODITEM_TRANSMASTER.TRANSSTATUS = fOODITEM_TRANSMASTER.TRANSSTATUS;
}
else
{
tempFOODITEM_TRANSMASTER.TRANSSTATUS = transStatus;
}
tempFOODITEM_TRANSMASTER.REFCODE = fOODITEM_TRANSMASTER.REFCODE;
tempFOODITEM_TRANSMASTER.RECID = fOODITEM_TRANSMASTER.RECID;
tempFOODITEM_TRANSMASTER.RECDATE = fOODITEM_TRANSMASTER.RECDATE;
tempFOODITEM_TRANSMASTER.STOREID = fOODITEM_TRANSMASTER.STOREID;
tempFOODITEM_TRANSMASTER.CREATEDON = fOODITEM_TRANSMASTER.CREATEDON;
tempFOODITEM_TRANSMASTER.CREATEDBY = fOODITEM_TRANSMASTER.CREATEDBY;
tempFOODITEM_TRANSMASTER.UPDATEDON = DateTime.Now;
tempFOODITEM_TRANSMASTER.UPDATEDBY = aGENT.AGENTID;
bool result = FOODITEM_TRANSMASTERManager.UpdateFOODITEM_TRANSMASTER(tempFOODITEM_TRANSMASTER);
}
private void showFoodTRANSData(string refCode)
{
FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
fOODITEM_TRANSMASTER = FOODITEM_TRANSMASTERManager.GetFOODITEM_TRANSMASTERByRefCode(refCode);
if (fOODITEM_TRANSMASTER == null)
{
panData.Visible = false;
panSearch.Visible = true;
}
else
{
panData.Visible = true;
panSearch.Visible = true;
int senderID = fOODITEM_TRANSMASTER.CID;
int receiverID = fOODITEM_TRANSMASTER.RECID;
int locationID = fOODITEM_TRANSMASTER.LID;
int fOODITEM_TRANSMASTERID = fOODITEM_TRANSMASTER.FOODITEM_TRANSMASTERID;
hfCUSTID.Value = senderID.ToString();
hfRECID.Value = receiverID.ToString();
hfFOODTRANSID.Value = fOODITEM_TRANSMASTERID.ToString();
loadSenderInfo(senderID);
loadReceiverInfo(receiverID);
loadLocation(locationID);
GetlocationInfo();
loadFoodItemGrid(fOODITEM_TRANSMASTERID);
CalculateTotalAmount();
}
}
private void loadReport()
{
List <FOODITEM_TRANSMASTER> fOODITEM_TRANSMASTER = new List <FOODITEM_TRANSMASTER>();
fOODITEM_TRANSMASTER = FOODITEM_TRANSMASTERManager.GetAllFOODITEM_TRANSMASTERsForReport(loadStatus(), getLocationIDs(), int.Parse(ddlAgent.SelectedValue), txtFromDate.Text, txtToDate.Text, int.Parse(txtMoney.Text == "" ? "0" : txtMoney.Text));
List <FOODITEM_TRANSMASTER> fOODITEM_TRANSMASTERFinal = new List <FOODITEM_TRANSMASTER>();
int count = 0;
for (int i = 0; i < fOODITEM_TRANSMASTER.Count; i++)
{
count = fOODITEM_TRANSMASTERFinal.FindAll(x => x.LID == fOODITEM_TRANSMASTER[i].LID).Count;
if (count == 0)
{
fOODITEM_TRANSMASTERFinal.Add(fOODITEM_TRANSMASTER[i]);
}
}
gvLocation.DataSource = fOODITEM_TRANSMASTERFinal;
gvLocation.DataBind();
calculateTotalAmount();
}
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();
}
}
