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(); } }