public static List <ATTInvItems> GetInvItems(ATTInvItems obj) { List <ATTInvItems> lstitems = new List <ATTInvItems>(); try { foreach (DataRow row in DLLInvItems.getInvItems(obj).Rows) { ATTInvItems objitems = new ATTInvItems(); objitems.ItemsCategoryID = int.Parse(row["ITEMS_CATEGORY_ID"].ToString()); objitems.ItemsSubCategoryID = int.Parse(row["ITEMS_SUB_CATEGORY_ID"].ToString()); objitems.ItemsID = int.Parse(row["ITEMS_ID"].ToString()); objitems.ItemsCD = row["ITEMS_CD"].ToString(); objitems.ItemsName = row["ITEMS_NAME"].ToString(); objitems.ItemsShortName = row["ITEMS_SHORT_NAME"].ToString(); objitems.ItemsTypeID = int.Parse(row["ITEMS_TYPE_ID"].ToString()); objitems.ItemsUnitID = int.Parse(row["ITEMS_UNIT_ID"].ToString()); // objitems.ItemsSpecification = row["ITEMS_SPECIFICATIONS"].ToString(); //objitems.IssuedTo = row["ISSUED_TO"].ToString(); objitems.Active = row["active"].ToString(); lstitems.Add(objitems); } return(lstitems); } catch (Exception ex) { throw ex; } }
// <summary> /// Validates ItemUnit object /// </summary> /// <param name="obj">ATTInvItemUnit object</param> /// <returns>ObjectValidation object</returns> public static ObjectValidation Validate(ATTInvItems obj) { ObjectValidation OV = new ObjectValidation(); if (obj.ItemsName == "") { OV.IsValid = false; OV.ErrorMessage = "Items name cannot be empty."; return(OV); } if (obj.ItemsCategoryID < 0) { OV.IsValid = false; OV.ErrorMessage = "Please select Item Category"; return(OV); } if (obj.ItemsTypeID < 0) { OV.IsValid = false; OV.ErrorMessage = "Please select Item type"; return(OV); } if (obj.ItemsUnitID < 0) { OV.IsValid = false; OV.ErrorMessage = "Please select Item unit"; return(OV); } return(OV); }
protected void btnSearch_Click(object sender, EventArgs e) { if (DDLItemCategory.SelectedIndex < 1 && ddlSubCategory.SelectedIndex < 1) { lblStatusMessage.Text = "Select atleast one Search Criteria"; programmaticModalPopup.Show(); return; } ATTInvItems obj = new ATTInvItems(); if (DDLItemCategory.SelectedIndex > 0) { obj.ItemsCategoryID = int.Parse(DDLItemCategory.SelectedValue); } if (ddlSubCategory.SelectedIndex > 0) { obj.ItemsSubCategoryID = int.Parse(ddlSubCategory.SelectedValue); } obj.Active = "Y"; List <ATTInvItems> LST = BLLInvItems.GetInvItems(obj); Session["InvItems"] = LST; grdInvOrgItems.DataSource = LST; grdInvOrgItems.DataBind(); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { List <ATTInvItems> lst = (List <ATTInvItems>)Session["Items"]; string active; active = chkActive.Checked ? "Y" : "N"; List <ATTInvItems> lstitems = new List <ATTInvItems>(); ATTInvItems objitem = new ATTInvItems( int.Parse((DDLItemCategory_Rqd.SelectedValue).ToString()), int.Parse((DDLItemsSubCategory_Rqd.SelectedValue).ToString()), 0, txtItemCD.Text, txtItemName_Rqd.Text, txtItemShortName.Text, int.Parse((DDLItemType_Rqd.SelectedValue).ToString()), int.Parse((DDLItemUnit_Rqd.SelectedValue).ToString()), active, this.User.UserName); //"sj"); ObjectValidation OV = BLLInvItems.Validate(objitem); if (OV.IsValid == false) { this.lblStatus.Text = OV.ErrorMessage; return; } if (lstInvItem.SelectedIndex < 0) { objitem.Action = "A"; } else { objitem.Action = "E"; objitem.ItemsID = int.Parse((lstInvItem.SelectedValue).ToString()); } lstitems.Add(objitem); BLLInvItems.SaveItems(lstitems); if (lstInvItem.SelectedIndex < 0 && objitem.Active == "Y") { lst.Add(objitem); } else { lst[this.lstInvItem.SelectedIndex] = objitem; } this.lblStatusMessage.Text = "Items successfully saved."; this.programmaticModalPopup.Show(); lstInvItem.DataSource = lst; lstInvItem.DataTextField = "ItemsName"; lstInvItem.DataValueField = "ItemsID"; lstInvItem.DataBind(); ClearControls(1); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
protected void ddlSubCategory_SelectedIndexChanged(object sender, EventArgs e) { try { if (ddlSubCategory_rqd.SelectedIndex > 0) { ATTInvItems obj = new ATTInvItems(); obj.ItemsCategoryID = int.Parse(ddlCategory_rqd.SelectedValue); obj.ItemsSubCategoryID = int.Parse(ddlSubCategory_rqd.SelectedValue); obj.Active = "Y"; Session["DakhilaItems"] = BLLInvItems.GetInvItems(obj); //Session["DakhilaItems"] = BLLInvOrgItemsPrice.GetOrgInvItemsPrice(9, int.Parse(ddlCategory.SelectedValue), int.Parse(ddlSubCategory.SelectedValue)); ddlItems_rqd.DataSource = (List <ATTInvItems>)Session["DakhilaItems"]; ddlItems_rqd.DataTextField = "ItemsName"; ddlItems_rqd.DataValueField = "ItemsID"; ddlItems_rqd.DataBind(); ListItem a = new ListItem(); a.Selected = true; a.Text = "----छान्नुहोस----"; a.Value = "0"; ddlItems_rqd.Items.Insert(0, a); ddlItems_rqd.Enabled = true; } else { ddlItems_rqd.SelectedIndex = -1; ddlItems_rqd.Enabled = false; } //txtQty_cat.Text = ""; } catch (Exception ex) { throw (ex); } }
protected void DDLItemsSubCategory_Rqd_SelectedIndexChanged(object sender, EventArgs e) { ClearControls(3); try { List <ATTInvItemsCategory> lstItemsCategory = (List <ATTInvItemsCategory>)Session["Item_ItemCategory"]; ATTInvItems obj = new ATTInvItems(); obj.ItemsCategoryID = lstItemsCategory[DDLItemCategory_Rqd.SelectedIndex].ItemsCategoryID; obj.ItemsSubCategoryID = int.Parse((DDLItemsSubCategory_Rqd.SelectedValue).ToString()); List <ATTInvItems> lstItems = BLLInvItems.GetInvItems(obj); Session["Items"] = lstItems; lstInvItem.DataSource = lstItems; lstInvItem.DataTextField = "ItemsName"; lstInvItem.DataValueField = "ItemsID"; lstInvItem.DataBind(); } catch (Exception ex) { lblStatus.Text = ex.Message; } }
//public static DataTable getInvItems(int itemcategoryID, string active) //{ // List<OracleParameter> para = new List<OracleParameter>(); // para.Add(Utilities.GetOraParam(":P_CATEGORY_ID", itemcategoryID, OracleDbType.Int64, ParameterDirection.Input)); // para.Add(Utilities.GetOraParam(":P_ACTIVE", active, OracleDbType.Varchar2, ParameterDirection.Input)); // para.Add(Utilities.GetOraParam(":P_RC", null, OracleDbType.RefCursor, ParameterDirection.InputOutput)); // GetConnection getConn = new GetConnection(); // try // { // OracleConnection DBConn = getConn.GetDbConn(Module.OAS); // SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, "sp_inv_GET_ITEMS", para.ToArray()); // OracleDataReader reader = ((OracleRefCursor)para[2].Value).GetDataReader(); // DataTable tbl = new DataTable(); // tbl.Load(reader, LoadOption.OverwriteChanges); // return tbl; // } // catch (Exception ex) // { // throw ex; // } // finally // { // getConn.CloseDbConn(); // } //} public static DataTable getInvItems(ATTInvItems obj) { string strSql = "SELECT * FROM VW_INV_ITEMS_LIST WHERE 1=1"; List <OracleParameter> paramArray = new List <OracleParameter>(); if (obj.ItemsCategoryID > 0) { strSql += " AND ITEMS_CATEGORY_ID =:ItemsCategoryID"; paramArray.Add(Utilities.GetOraParam(":ItemsCategoryID", obj.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input)); } if (obj.ItemsSubCategoryID > 0 || obj.ItemsSubCategoryID == -1) { strSql += " AND ITEMS_SUB_CATEGORY_ID =:ItemsSubCategoryID"; paramArray.Add(Utilities.GetOraParam(":ItemsSubCategoryID", obj.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input)); } if (obj.Active != null) { if (obj.Active != "") { strSql += " AND ACTIVE =:Active"; paramArray.Add(Utilities.GetOraParam(":Active", obj.Active, OracleDbType.Varchar2, ParameterDirection.Input)); } } strSql += " ORDER BY ITEMS_CATEGORY_ID,ITEMS_SUB_CATEGORY_ID,ITEMS_NAME ASC"; try { DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, strSql, Module.OAS, paramArray.ToArray()); return((DataTable)ds.Tables[0]); } catch (Exception ex) { throw ex; } }