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