public static List <ATTInvOrgItemsKNJ> SearchItemsKNJ(int?itmCatID, int?itmSubCatID) { try { List <ATTInvOrgItemsKNJ> LSTItemsKNJ = new List <ATTInvOrgItemsKNJ>(); foreach (DataRow row in DLLInvOrgItemsKNJ.SearchItemsKNJ(itmCatID, itmSubCatID).Rows) { ATTInvOrgItemsKNJ obj = new ATTInvOrgItemsKNJ(); obj.OrgID = int.Parse(row["ORG_ID"].ToString()); obj.OrgName = row["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.KNJSeq = int.Parse(row["SEQ_NO"].ToString()); obj.ItemsAttrib = row["ITEMS_ATTRIBUTES"].ToString(); obj.VehRegNo = row["VEHICLE_REG_NO"].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.JI_KHA_PA_NO = row["JI_KHA_PA_NO"].ToString(); LSTItemsKNJ.Add(obj); } return(LSTItemsKNJ); } catch (Exception ex) { throw ex; } }
public static DataTable SearchItemsKNJ(ATTInvOrgItemsKNJ obj) { try { string strSelect = ""; strSelect = "SELECT * FROM VW_INV_ORG_ITEMS_KNJ WHERE ITEMS_STATUS='S' "; List <OracleParameter> ParamList = new List <OracleParameter>(); if (obj.OrgID > 0) { strSelect += " AND ORG_ID = :itmOrgID"; ParamList.Add(Utilities.GetOraParam(":itmOrgID", obj.OrgID, OracleDbType.Int64, ParameterDirection.Input)); } if (obj.ItemsCategoryID > 0) { strSelect += " AND ITEMS_CATEGORY_ID = :itmCatID"; ParamList.Add(Utilities.GetOraParam(":itmCatID", obj.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input)); } if (obj.ItemsSubCategoryID > 0) { strSelect += " AND ITEMS_SUB_CATEGORY_ID = :itmSubCatID"; ParamList.Add(Utilities.GetOraParam(":itmSubCatID", obj.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input)); } if (obj.ItemsID > 0) { strSelect += " AND ITEMS_ID = :itmID"; ParamList.Add(Utilities.GetOraParam(":itmID", obj.ItemsID, OracleDbType.Int64, ParameterDirection.Input)); } //if (obj.ItemsTypeID > 0) //{ // strSelect += " AND ITEMS_TYPE_ID = :itmTypeID"; // ParamList.Add(Utilities.GetOraParam(":itmTypeID", obj.ItemsTypeID, OracleDbType.Int64, ParameterDirection.Input)); //} GetConnection conn = new GetConnection(); OracleConnection con = conn.GetDbConn(Module.OAS); DataSet ds = SqlHelper.ExecuteDataset(con, CommandType.Text, strSelect, ParamList.ToArray()); return((DataTable)ds.Tables[0]); } catch (Exception ex) { throw ex; } }
protected void ddlItemsKNJ_SelectedIndexChanged(object sender, EventArgs e) { try { if (ddlItemsKNJ.SelectedIndex > 0) { int itemType = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeID; if (itemType == 2) { ATTInvOrgItemsKNJ obj = new ATTInvOrgItemsKNJ(); obj.OrgID = ((ATTUserLogin)Session["Login_User_Detail"]).OrgID; obj.ItemsCategoryID = int.Parse(ddlCategory.SelectedValue); obj.ItemsSubCategoryID = int.Parse(ddlSubCategory.SelectedValue); obj.ItemsID = int.Parse(ddlItemsKNJ.SelectedValue); List <ATTInvOrgItemsKNJ> lstKNJItems = BLLInvOrgItemsKNJ.SearchItemsKNJ(obj); this.grdKNJItems.DataSource = lstKNJItems; this.grdKNJItems.DataBind(); Session["KNJItems"] = lstKNJItems; txtQuantiy.ReadOnly = true; Panel1.Visible = true; } else { txtQuantiy.ReadOnly = false; } } } catch (Exception ex) { this.lblStatusMessage.Text = "Error Status"; this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } txtQuantiy.Text = ""; }
protected void grdItemsTrans_SelectedIndexChanged(object sender, EventArgs e) { List <ATTInvItemsTransfered> lstItemsTrans = ((List <ATTInvItemsTransfered>)Session["GrdData"]); int itemType = lstItemsTrans[grdItemsTrans.SelectedIndex].ItemsTypeID; this.ddlCategory.SelectedValue = lstItemsTrans[grdItemsTrans.SelectedIndex].ItemsCategoryID.ToString(); List <ATTInvItemSubCategory> lst = GetItemSubCategory(int.Parse(ddlCategory.SelectedValue.ToString())); Session["SubCat"] = lst; ddlSubCategory.DataSource = lst; ddlSubCategory.DataTextField = "ItemsSubCategoryName"; ddlSubCategory.DataValueField = "ItemsSubCategoryID"; ddlSubCategory.DataBind(); this.ddlSubCategory.SelectedValue = lstItemsTrans[grdItemsTrans.SelectedIndex].ItemsSubCategoryID.ToString(); LoadDDLItems(); this.ddlItemsKNJ.SelectedValue = grdItemsTrans.SelectedRow.Cells[5].Text; if (itemType == 1) { this.txtQuantiy.Text = lstItemsTrans[grdItemsTrans.SelectedIndex].Quantity.ToString(); txtQuantiy.ReadOnly = false; } else if (itemType == 2) { Panel1.Visible = true; this.txtQuantiy.Text = ""; txtQuantiy.ReadOnly = true; ATTInvOrgItemsKNJ obj = new ATTInvOrgItemsKNJ(); obj.OrgID = ((ATTUserLogin)Session["Login_User_Detail"]).OrgID; obj.ItemsCategoryID = int.Parse(ddlCategory.SelectedValue); obj.ItemsSubCategoryID = int.Parse(ddlSubCategory.SelectedValue); obj.ItemsID = int.Parse(grdItemsTrans.SelectedRow.Cells[5].Text); //obj.ItemsTypeID = 2; List <ATTInvOrgItemsKNJ> lstKNJItems = BLLInvOrgItemsKNJ.SearchItemsKNJ(obj); this.grdKNJItems.DataSource = lstKNJItems; this.grdKNJItems.DataBind(); Session["KNJItems"] = lstKNJItems; txtQuantiy.ReadOnly = true; //getmatching items checked code goes here foreach (GridViewRow var in grdKNJItems.Rows) { int orgid = int.Parse(var.Cells[1].Text); int catid = int.Parse(var.Cells[2].Text); int subcatid = int.Parse(var.Cells[3].Text); int itemid = int.Parse(var.Cells[4].Text); int itemtypeid = int.Parse(var.Cells[5].Text); int seqno = int.Parse(var.Cells[9].Text); List <ATTInvItemsTransfered> lstData = (List <ATTInvItemsTransfered>)Session["ItemsTransfered"]; bool exists = lstData.Exists(delegate(ATTInvItemsTransfered objkvn) { return(objkvn.OrgID == orgid && objkvn.ItemsCategoryID == catid && objkvn.ItemsSubCategoryID == subcatid && objkvn.ItemsID == itemid && objkvn.ItemsTypeID == itemtypeid && objkvn.SeqNo == seqno ); } ); ((CheckBox)var.FindControl("chkItems")).Checked = exists; } } }
protected void btnKNJ_Click(object sender, EventArgs e) { try { int rowIndex = -1; List <ATTInvOrgItemsKNJ> lstKNJ = new List <ATTInvOrgItemsKNJ>(); List <ATTInvDakhila> lst = new List <ATTInvDakhila>(); if (Session["grdKnjRow"] != null) { GridViewRow gvRow = (GridViewRow)Session["grdKnjRow"]; rowIndex = gvRow.RowIndex; foreach (GridViewRow row in grdNonExpendible.Rows) { ATTInvOrgItemsKNJ objOKnj = new ATTInvOrgItemsKNJ(); objOKnj.OrgID = int.Parse(gvRow.Cells[1].Text); objOKnj.ItemsCategoryID = int.Parse(gvRow.Cells[2].Text); objOKnj.ItemsSubCategoryID = int.Parse(gvRow.Cells[3].Text); objOKnj.ItemsID = int.Parse(gvRow.Cells[4].Text); objOKnj.ItemsStatus = "S"; objOKnj.Action = "A"; objOKnj.EntryBy = entryBy; TextBox txtBox1 = (TextBox)row.FindControl("txtBox1"); TextBox txtBox2 = (TextBox)row.FindControl("txtBox2"); objOKnj.ItemsAttrib = txtBox1.Text; objOKnj.VehRegNo = txtBox2.Text; lstKNJ.Add(objOKnj); } if (Session["lstDak"] != null) { lst = (List <ATTInvDakhila>)Session["lstDak"]; } if (rowIndex != -1) { lst[rowIndex].LstKNJ = lstKNJ; Session["grdKnjRow"] = null; rowIndex = -1; } } this.programmaticCommentModalPopup.Hide(); } catch (Exception ex) { this.lblStatusMessageTitle.Text = "Error Status"; this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
public static bool SaveDakhila(List <ATTInvDakhila> lst) { string sp; GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); OracleParameter[] paramArray = new OracleParameter[11]; try { foreach (ATTInvDakhila objDak in lst) { sp = ""; if (objDak.JelaaKhataNo.Trim() != "") { ATTInvOrgItems objOItms = new ATTInvOrgItems(); objOItms.OrgID = int.Parse(objDak.OrgID.ToString()); objOItms.ItemsCategoryID = int.Parse(objDak.ItemsCategoryID.ToString()); objOItms.ItemsSubCategoryID = int.Parse(objDak.ItemsSubCategoryID.ToString()); objOItms.ItemsID = objDak.ItemsID; objOItms.PanNo = objDak.JelaaKhataNo; objOItms.Active = "Y"; objOItms.Action = "A"; objOItms.EntryBy = objDak.EntryBy; DLLInvOrgItems.SaveOrgItems(objOItms, Tran); } if (objDak.Action == "A") { sp = "sp_inv_add_direct_entry"; } else if (objDak.Action == "E") { sp = "sp_inv_edit_direct_entry"; } if (sp != "") { paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", objDak.OrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":p_items_category_id", objDak.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam(":p_items_sub_category_id", objDak.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input); paramArray[3] = Utilities.GetOraParam(":p_items_id", objDak.ItemsID, OracleDbType.Int64, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam(":p_seq_no", objDak.DirectEntrySeq, OracleDbType.Int64, ParameterDirection.InputOutput); paramArray[5] = Utilities.GetOraParam(":p_dir_entry_date", objDak.DirectEntryDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[6] = Utilities.GetOraParam(":p_dir_entry_type", objDak.DirectEntryType, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[7] = Utilities.GetOraParam(":p_don_organization", objDak.DonationOrg, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[8] = Utilities.GetOraParam(":p_items_unit_price", objDak.UnitPrice, OracleDbType.Int64, ParameterDirection.Input); paramArray[9] = Utilities.GetOraParam(":p_total_quantity", objDak.Quantity, OracleDbType.Int64, ParameterDirection.Input); paramArray[10] = Utilities.GetOraParam(":p_entry_by", objDak.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray); } if (objDak.ItemsTypeID == 2 && objDak.LstKNJ.Count > 0) { DLLInvOrgItemsKNJ.SaveOrgItemsKNJ(objDak.LstKNJ, Tran); } else if (objDak.ItemsTypeID == 2) { int i = 0; List <ATTInvOrgItemsKNJ> lstKNJ = new List <ATTInvOrgItemsKNJ>(); while (i < objDak.Quantity) { ATTInvOrgItemsKNJ objOKnj = new ATTInvOrgItemsKNJ(); objOKnj.OrgID = objDak.OrgID; objOKnj.ItemsCategoryID = objDak.ItemsCategoryID; objOKnj.ItemsSubCategoryID = objDak.ItemsSubCategoryID; objOKnj.ItemsID = objDak.ItemsID; objOKnj.ItemsStatus = "S"; objOKnj.Action = "A"; objOKnj.EntryBy = objDak.EntryBy; lstKNJ.Add(objOKnj); i++; } if (lstKNJ.Count > 0) { DLLInvOrgItemsKNJ.SaveOrgItemsKNJ(lstKNJ, Tran); } } } Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw (ex); } finally { GetConn.CloseDbConn(); } }