public static List <ATTInvItemsTransfered> GetItemsTransfKNJList() { List <ATTInvItemsTransfered> lstItemsTransKNJLst = new List <ATTInvItemsTransfered>(); try { foreach (DataRow row in DLLInvItemsTransfered.getItemsTransfKNJ().Rows) { ATTInvItemsTransfered obj = new ATTInvItemsTransfered(); obj.OrgID = int.Parse(row["ORG_ID"].ToString()); obj.TransSEQ = int.Parse(row["TRFD_SEQ"].ToString()); obj.TransORG = int.Parse(row["TRFD_ORG"].ToString()); obj.TransfOrgName = row["TRFD_ORG_NAME"].ToString(); obj.ItemsCategoryID = int.Parse(row["ITEMS_CATEGORY_ID"].ToString()); obj.ItemsCategoryName = row["ITEMS_CATEGORY_NAME"].ToString(); obj.ItemsSubCategoryID = int.Parse(row["ITEMS_SUB_CATEGORY_ID"].ToString()); obj.ItemsSubCategoryName = row["ITEMS_SUB_CATEGORY_NAME"].ToString(); obj.ItemsID = int.Parse(row["ITEMS_ID"].ToString()); obj.ItemsName = row["ITEMS_NAME"].ToString(); obj.ItemsTypeID = int.Parse(row["ITEMS_TYPE_ID"].ToString()); obj.ItemsTypeName = row["ITEMS_TYPE_NAME"].ToString(); obj.ItemsUnitID = int.Parse(row["ITEMS_UNIT_ID"].ToString()); obj.ItemsUnitName = row["ITEMS_UNIT_NAME"].ToString(); // obj.Quantity = int.Parse(row["QUANTITY"].ToString()); obj.DecisionDate = row["DECISION_DATE"].ToString(); obj.TransDate = row["TRFD_DATE"].ToString(); obj.TransVia = int.Parse(row["TRFD_VIA"].ToString()); obj.TransOrgUnit = int.Parse(row["TRFD_ORG_UNIT"].ToString()); obj.TransTo = int.Parse(row["TRFD_TO"].ToString()); obj.SeqNo = int.Parse(row["SEQ_NO"].ToString()); if (row["TRFD_RCVD_BY"].ToString() != "") { obj.TransRecvBy = int.Parse(row["TRFD_RCVD_BY"].ToString()); } else { obj.TransRecvBy = null; } obj.TransRecvDate = row["TRFD_RCVD_DATE"].ToString(); lstItemsTransKNJLst.Add(obj); } return(lstItemsTransKNJLst); } catch (Exception) { throw; } }
protected void btnAdd_Click(object sender, EventArgs e) { try { if (ddlCategory.SelectedIndex == 0) { this.lblStatusMessage.Text = "क्रिपया सामुह मा भाको समान छान्नुहोस्"; this.programmaticModalPopup.Show(); return; } if (ddlSubCategory.SelectedIndex == 0) { this.lblStatusMessage.Text = "क्रिपया उप-सामुह मा भाको समान छान्नुहोस्"; this.programmaticModalPopup.Show(); return; } if (ddlItemsKNJ.SelectedIndex == 0) { this.lblStatusMessage.Text = "क्रिपया हस्तान्तरण गर्न लागेको समान छान्नुहोस्"; this.programmaticModalPopup.Show(); return; } if (Session["ItemsTransfered"] == null) { Session["ItemsTransfered"] = new List <ATTInvItemsTransfered>(); } List <ATTInvItemsTransfered> LSTItemsTrans = (List <ATTInvItemsTransfered>)Session["ItemsTransfered"]; Panel1.Visible = false; int count = 0; int itemType = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeID; if (itemType == 2) { #region itemtype 2 if (this.grdItemsTrans.SelectedIndex == -1) { //if (ValidationControl() == true) //{ foreach (GridViewRow rw in grdKNJItems.Rows) { if (((CheckBox)rw.FindControl("chkItems")).Checked == true) { count++; ATTInvItemsTransfered objItemsTrans = new ATTInvItemsTransfered(); ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]); objItemsTrans.OrgID = user.OrgID; objItemsTrans.ItemsCategoryID = int.Parse(this.ddlCategory.SelectedValue); objItemsTrans.ItemsCategoryName = ((List <ATTInvItemsCategory>)Session["Cat"])[ddlCategory.SelectedIndex - 1].ItemsCategoryName; objItemsTrans.ItemsSubCategoryID = int.Parse(this.ddlSubCategory.SelectedValue); objItemsTrans.ItemsSubCategoryName = ((List <ATTInvItemSubCategory>)Session["SubCat"])[ddlSubCategory.SelectedIndex].ItemsSubCategoryName; objItemsTrans.ItemsID = int.Parse(this.ddlItemsKNJ.SelectedValue); objItemsTrans.ItemsName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemName; objItemsTrans.ItemsTypeID = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeID; objItemsTrans.ItemsTypeName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeName; objItemsTrans.Quantity = count; objItemsTrans.SeqNo = int.Parse(rw.Cells[9].Text); objItemsTrans.Action = "A"; LSTItemsTrans.Add(objItemsTrans); } } //} } else if (this.grdItemsTrans.SelectedIndex > -1) { #region edit int orgid = int.Parse(grdItemsTrans.SelectedRow.Cells[0].Text); int catid = int.Parse(grdItemsTrans.SelectedRow.Cells[1].Text); int subcatid = int.Parse(grdItemsTrans.SelectedRow.Cells[3].Text); int itemid = int.Parse(grdItemsTrans.SelectedRow.Cells[5].Text); int itemtypeid = int.Parse(grdItemsTrans.SelectedRow.Cells[7].Text); ///////// int i = LSTItemsTrans.RemoveAll(delegate(ATTInvItemsTransfered objkvn) { return(objkvn.OrgID == orgid && objkvn.ItemsCategoryID == catid && objkvn.ItemsSubCategoryID == subcatid && objkvn.ItemsID == itemid && objkvn.ItemsTypeID == itemtypeid ); } ); //////////////// //if (ValidationControl() == true) //{ foreach (GridViewRow rw in grdKNJItems.Rows) { if (((CheckBox)rw.FindControl("chkItems")).Checked == true) { count++; ATTInvItemsTransfered objItemsTrans = new ATTInvItemsTransfered(); ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]); objItemsTrans.OrgID = user.OrgID; objItemsTrans.ItemsCategoryID = int.Parse(this.ddlCategory.SelectedValue); objItemsTrans.ItemsCategoryName = ((List <ATTInvItemsCategory>)Session["Cat"])[ddlCategory.SelectedIndex - 1].ItemsCategoryName; objItemsTrans.ItemsSubCategoryID = int.Parse(this.ddlSubCategory.SelectedValue); objItemsTrans.ItemsSubCategoryName = ((List <ATTInvItemSubCategory>)Session["SubCat"])[ddlSubCategory.SelectedIndex].ItemsSubCategoryName; objItemsTrans.ItemsID = int.Parse(this.ddlItemsKNJ.SelectedValue); objItemsTrans.ItemsName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemName; objItemsTrans.ItemsTypeID = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeID; objItemsTrans.ItemsTypeName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeName; objItemsTrans.Quantity = count; objItemsTrans.SeqNo = int.Parse(rw.Cells[9].Text); objItemsTrans.Action = "A"; LSTItemsTrans.Add(objItemsTrans); } } //} #endregion } Clearcontrols(false); #endregion } else { #region itemtype1 if (this.grdItemsTrans.SelectedIndex == -1) { if (this.txtQuantiy.Text == "") { lblStatusMessage.Text = "quantity missing"; this.programmaticModalPopup.Show(); return; } else if (int.Parse(txtQuantiy.Text.Trim()) > ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlSubCategory.SelectedIndex - 1].Quantity) { lblStatusMessage.Text = "quantity transferred is greater than available"; this.programmaticModalPopup.Show(); return; } ATTInvItemsTransfered objItemsTrans = new ATTInvItemsTransfered(); ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]); objItemsTrans.OrgID = user.OrgID; objItemsTrans.ItemsCategoryID = int.Parse(this.ddlCategory.SelectedValue); objItemsTrans.ItemsCategoryName = ((List <ATTInvItemsCategory>)Session["Cat"])[ddlCategory.SelectedIndex - 1].ItemsCategoryName; objItemsTrans.ItemsSubCategoryID = int.Parse(this.ddlSubCategory.SelectedValue); objItemsTrans.ItemsSubCategoryName = ((List <ATTInvItemSubCategory>)Session["SubCat"])[ddlSubCategory.SelectedIndex].ItemsSubCategoryName; objItemsTrans.ItemsID = int.Parse(this.ddlItemsKNJ.SelectedValue); objItemsTrans.ItemsName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemName; objItemsTrans.ItemsTypeID = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeID; objItemsTrans.ItemsTypeName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeName; objItemsTrans.Quantity = int.Parse(this.txtQuantiy.Text.Trim()); objItemsTrans.Action = "A"; objItemsTrans.EntryBy = user.UserName; LSTItemsTrans.Add(objItemsTrans); Session["ItemsTransfered"] = LSTItemsTrans; } else if (this.grdItemsTrans.SelectedIndex > -1) { ATTInvItemsTransfered objItemsTrans = LSTItemsTrans[this.grdItemsTrans.SelectedIndex]; ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]); objItemsTrans.ItemsCategoryID = int.Parse(this.ddlCategory.SelectedValue); objItemsTrans.ItemsCategoryName = ((List <ATTInvItemsCategory>)Session["Cat"])[ddlCategory.SelectedIndex - 1].ItemsCategoryName; objItemsTrans.ItemsSubCategoryID = int.Parse(this.ddlSubCategory.SelectedValue); objItemsTrans.ItemsSubCategoryName = ((List <ATTInvItemSubCategory>)Session["SubCat"])[ddlSubCategory.SelectedIndex].ItemsSubCategoryName; objItemsTrans.ItemsID = int.Parse(this.ddlItemsKNJ.SelectedValue); objItemsTrans.ItemsName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemName; if (this.txtQuantiy.Text != "") { objItemsTrans.Quantity = int.Parse(this.txtQuantiy.Text.Trim()); } objItemsTrans.Action = (((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].Action == "A") ? "A" : "E"; Session["ItemsTransfered"] = LSTItemsTrans; } Clearcontrols(false); #endregion } List <ATTInvItemsTransfered> lstNew = new List <ATTInvItemsTransfered>(); foreach (ATTInvItemsTransfered var in (List <ATTInvItemsTransfered>)Session["ItemsTransfered"]) { if (var.ItemsTypeID == 1) { lstNew.Add(var); } else if (var.ItemsTypeID == 2) { int index = -1; index = lstNew.FindIndex( delegate(ATTInvItemsTransfered obj) { return(var.OrgID == obj.OrgID && var.ItemsCategoryID == obj.ItemsCategoryID && var.ItemsSubCategoryID == obj.ItemsSubCategoryID && var.ItemsID == obj.ItemsID && var.ItemsTypeID == obj.ItemsTypeID ); } ); if (index < 0) { lstNew.Add(var); } else { if (lstNew[index].Quantity < var.Quantity) { lstNew[index].Quantity = var.Quantity; } } } } foreach (ATTInvItemsTransfered var in lstNew) { List <ATTInvItemsTransfered> objlst = LSTItemsTrans.FindAll( delegate(ATTInvItemsTransfered obj) { return(var.OrgID == obj.OrgID && var.ItemsCategoryID == obj.ItemsCategoryID && var.ItemsSubCategoryID == obj.ItemsSubCategoryID && var.ItemsID == obj.ItemsID && var.ItemsTypeID == obj.ItemsTypeID ); } ); foreach (ATTInvItemsTransfered var1 in objlst) { var1.Quantity = var.Quantity; } } Session["GrdData"] = lstNew; Panel3.Visible = lstNew.Count > 0 ? true : false; grdItemsTrans.DataSource = lstNew; grdItemsTrans.DataBind(); grdItemsTrans.SelectedIndex = -1; } catch (Exception ex) { this.lblStatusMessage.Text = "Error:" + ex.Message; this.programmaticModalPopup.Show(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (ddlItemsType.SelectedIndex == 0) { this.lblStatusMessage.Text = "समानको किसिम छान्नुहोस्"; this.programmaticModalPopup.Show(); return; } if (this.txtReceivedDate.Text == "") { this.lblStatusMessage.Text = "बुझिलिएको मिति हाल्नुहोस्"; this.programmaticModalPopup.Show(); return; } List <ATTInvItemsTransfered> lstNew = new List <ATTInvItemsTransfered>(); List <ATTInvItemsTransfered> lstItemsTransfKNJ = new List <ATTInvItemsTransfered>(); List <ATTInvItemsTransfered> lstItemsTransfKBJ = new List <ATTInvItemsTransfered>(); if (this.ddlItemsType.SelectedIndex == 2) { lstItemsTransfKNJ = (List <ATTInvItemsTransfered>)Session["ItemsTransfKNJ"]; } else { lstItemsTransfKBJ = (List <ATTInvItemsTransfered>)Session["ItemsTransfKBJ"]; } ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]); if (lstItemsTransfKNJ.Count > 0) { if (((CheckBox)grdItemsTransfRecv.HeaderRow.FindControl("chkAllItems")).Checked == true) { foreach (ATTInvItemsTransfered var in lstItemsTransfKNJ) { var.OrgID = var.OrgID; var.ItemsCategoryID = var.ItemsCategoryID; var.ItemsSubCategoryID = var.ItemsSubCategoryID; var.ItemsID = var.ItemsID; var.TransORG = var.TransORG; var.TransSEQ = var.TransSEQ; var.SeqNo = var.SeqNo; // var.Quantity = var.Quantity; var.DecisionDate = var.DecisionDate; var.TransDate = var.TransDate; var.TransVia = var.TransVia; var.TransOrgUnit = var.TransOrgUnit; var.TransTo = var.TransTo; var.TransRecvDate = this.txtReceivedDate.Text.Trim(); var.TransRecvBy = user.OrgID; var.ReturnBy = var.ReturnBy; var.ReturnDate = var.ReturnDate; var.ReturnVia = var.ReturnVia; var.ReturnRecvBy = var.ReturnRecvBy; var.ReturnRecvDate = var.ReturnRecvDate; var.Action = "E"; } if (BLLInvItemsTransfered.SaveItemsTransfer(lstItemsTransfKNJ, "receive")) { this.lblStatusMessage.Text = "Received Items Saved"; this.programmaticModalPopup.Show(); Session["ItemsTransfKNJ"] = null; } } else { int count = 0; foreach (GridViewRow row in grdItemsTransfRecv.Rows) { if (((CheckBox)row.FindControl("chkItems")).Checked == true) { ATTInvItemsTransfered obj = new ATTInvItemsTransfered(); obj.OrgID = int.Parse(row.Cells[1].Text); obj.TransSEQ = int.Parse(row.Cells[2].Text); obj.TransORG = int.Parse(row.Cells[3].Text); obj.TransfOrgName = row.Cells[4].Text; //obj.Quantity = int.Parse(row.Cells[5].Text); obj.DecisionDate = row.Cells[6].Text; obj.TransDate = row.Cells[7].Text; obj.TransVia = int.Parse(row.Cells[8].Text); obj.TransOrgUnit = int.Parse(row.Cells[9].Text); obj.TransTo = int.Parse(row.Cells[10].Text); obj.ItemsCategoryID = int.Parse(row.Cells[11].Text); obj.ItemsCategoryName = row.Cells[12].Text; obj.ItemsSubCategoryID = int.Parse(row.Cells[13].Text); obj.ItemsSubCategoryName = row.Cells[14].Text; obj.ItemsID = int.Parse(row.Cells[15].Text); obj.ItemsName = row.Cells[16].Text; obj.ItemsTypeID = int.Parse(row.Cells[17].Text); obj.ItemsTypeName = row.Cells[18].Text; obj.ItemsUnitID = int.Parse(row.Cells[19].Text); obj.ItemsUnitName = row.Cells[20].Text; obj.SeqNo = int.Parse(row.Cells[21].Text); obj.TransRecvBy = user.OrgID; obj.TransRecvDate = this.txtReceivedDate.Text.Trim(); obj.ReturnBy = null; obj.ReturnDate = ""; obj.ReturnRecvDate = ""; obj.ReturnVia = null; obj.Action = "E"; lstNew.Add(obj); count++; } } if (BLLInvItemsTransfered.SaveItemsTransfer(lstNew, "receive")) { this.lblStatusMessage.Text = "Received Items Saved"; this.programmaticModalPopup.Show(); Session["ItemsTransfKNJ"] = null; } } } else if (lstItemsTransfKBJ.Count > 0) { if (((CheckBox)grdItemsTransfRecv.HeaderRow.FindControl("chkAllItems")).Checked == true) { foreach (ATTInvItemsTransfered var in lstItemsTransfKBJ) { var.OrgID = var.OrgID; var.ItemsCategoryID = var.ItemsCategoryID; var.ItemsSubCategoryID = var.ItemsSubCategoryID; var.ItemsID = var.ItemsID; var.TransORG = var.TransORG; var.TransSEQ = var.TransSEQ; var.Quantity = var.Quantity; var.DecisionDate = var.DecisionDate; var.TransDate = var.TransDate; var.TransVia = var.TransVia; var.TransOrgUnit = var.TransOrgUnit; var.TransTo = var.TransTo; var.TransRecvDate = this.txtReceivedDate.Text.Trim(); var.TransRecvBy = user.OrgID; var.ReturnBy = var.ReturnBy; var.ReturnDate = var.ReturnDate; var.ReturnVia = var.ReturnVia; var.ReturnRecvBy = var.ReturnRecvBy; var.ReturnRecvDate = var.ReturnRecvDate; var.Action = "E"; } if (BLLInvItemsTransfered.SaveItemsTransfer(lstItemsTransfKBJ, "receive")) { this.lblStatusMessage.Text = "Received Items Saved"; this.programmaticModalPopup.Show(); Session["ItemsTransfKBJ"] = null; } } else { int count = 0; foreach (GridViewRow row in grdItemsTransfRecv.Rows) { if (((CheckBox)row.FindControl("chkItems")).Checked == true) { ATTInvItemsTransfered obj = new ATTInvItemsTransfered(); obj.OrgID = int.Parse(row.Cells[1].Text); obj.TransSEQ = int.Parse(row.Cells[2].Text); obj.TransORG = int.Parse(row.Cells[3].Text); obj.TransfOrgName = row.Cells[4].Text; obj.Quantity = int.Parse(row.Cells[5].Text); obj.DecisionDate = row.Cells[6].Text; obj.TransDate = row.Cells[7].Text; obj.TransVia = int.Parse(row.Cells[8].Text); obj.TransOrgUnit = int.Parse(row.Cells[9].Text); obj.TransTo = int.Parse(row.Cells[10].Text); obj.ItemsCategoryID = int.Parse(row.Cells[11].Text); obj.ItemsCategoryName = row.Cells[12].Text; obj.ItemsSubCategoryID = int.Parse(row.Cells[13].Text); obj.ItemsSubCategoryName = row.Cells[14].Text; obj.ItemsID = int.Parse(row.Cells[15].Text); obj.ItemsName = row.Cells[16].Text; obj.ItemsTypeID = int.Parse(row.Cells[17].Text); obj.ItemsTypeName = row.Cells[18].Text; obj.ItemsUnitID = int.Parse(row.Cells[19].Text); obj.ItemsUnitName = row.Cells[20].Text; obj.TransRecvBy = user.OrgID; obj.TransRecvDate = this.txtReceivedDate.Text.Trim(); obj.ReturnBy = null; obj.ReturnDate = ""; obj.ReturnRecvDate = ""; obj.ReturnVia = null; obj.Action = "E"; lstNew.Add(obj); count++; } } if (BLLInvItemsTransfered.SaveItemsTransfer(lstNew, "receive")) { this.lblStatusMessage.Text = "Received Items Saved"; this.programmaticModalPopup.Show(); Session["ItemsTransfKBJ"] = null; } } } } catch (Exception ex) { throw ex; } ClearControls(); }