public static List <ATTInvItemsCategory> GetItemCategoryList(int?itemCategoryID, string itemCatActive, string itemSubCatActive, bool ContainsDefault)
{
List <ATTInvItemsCategory> lstItemCategoryList = new List <ATTInvItemsCategory>();
//List<ATTInvItemsSubCategory> lstItemsSubCategory = BLLInvItemsSubCategory.GetItemSubCategory(itemCategoryID, itemSubCatActive, ContainsDefault);
try
{
foreach (DataRow row in DLLInvItemsCategory.GetItemCategory(itemCategoryID, itemCatActive).Rows)
{
ATTInvItemsCategory obj = new ATTInvItemsCategory(int.Parse(row["ITEMS_CATEGORY_ID"].ToString()), row["ITEMS_CATEGORY_NAME"].ToString());
obj.LstItemSubCategory = BLLInvItemsSubCategory.GetItemSubCategory(obj.ItemsCategoryID, itemSubCatActive, ContainsDefault); //lstItemsSubCategory.FindAll(delegate(ATTInvItemsSubCategory subCat) { return subCat.ItemsCategoryID == obj.ItemCategoryID; });
lstItemCategoryList.Add(obj);
}
if (lstItemCategoryList.Count > 0 && ContainsDefault == true)
{
ATTInvItemsCategory def = new ATTInvItemsCategory();
def.ItemsCategoryID = -1;
def.ItemsCategoryName = "----छान्नुहोस----";
lstItemCategoryList.Insert(0, def);
}
return(lstItemCategoryList);
}
catch (Exception ex)
{
throw ex;
}
}
protected void lstItemCategory_SelectedIndexChanged(object sender, EventArgs e)
{
chkICActive.Checked = true;
chkISCActive.Checked = true;
this.grdItemSubCategory.DataSource = "";
grdItemSubCategory.DataBind();
//grdItemSubCategory.SelectedIndex = -1;
List <ATTInvItemsCategory> invItemsCategory = (List <ATTInvItemsCategory>)Session["ItemCategory_List"];
ATTInvItemsCategory obj = invItemsCategory[this.lstItemCategory.SelectedIndex].CreateDeepCopy();
Session["ItemCategory"] = obj;
this.txtItemCategoryName_Rqd.Text = obj.ItemsCategoryName;
string chk = obj.Active;
if (chk == "Y")
{
this.chkICActive.Checked = true;
}
else
{
this.chkICActive.Checked = false;
}
this.grdItemSubCategory.DataSource = obj.LstItemSubCategory;
grdItemSubCategory.DataBind();
this.txSubCategory_Rqd.Text = "";
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Login_User_Detail"] == null)
{
Response.Redirect("~/MODULES/Login.aspx", true);
}
////block if from URL
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
if (!Page.IsPostBack)
{
LoadItemCategoryList();
Session["ItemCategory"] = new ATTInvItemsCategory();//
}
/*
* if (user.MenuList.ContainsKey("5,5,1") == true)
* {
* if (!Page.IsPostBack)
* {
* // load grid;
*
* }
* }
* else
* Response.Redirect("~/MODULES/Login.aspx", true);
*
*/
}
public static List <ATTInvItemsCategory> GetItemCategoryList(int?itemCategoryID, string active)
{
List <ATTInvItemsCategory> lstitemCategoryList = new List <ATTInvItemsCategory>();
try
{
foreach (DataRow row in DLLInvItemsCategory.GetItemCategoryTable(itemCategoryID, active).Rows)
{
ATTInvItemsCategory itemsCategory = new ATTInvItemsCategory();
itemsCategory.ItemsCategoryID = int.Parse(row["items_category_id"].ToString());
itemsCategory.ItemsCategoryName = row["items_category_name"].ToString();
itemsCategory.Active = row["active"].ToString();
itemsCategory.Action = "";
//itemsCategory.Active = "Y";
//itemsCategory.EntryBy = row["entry_by"].ToString();
itemsCategory.LstItemSubCategory = BLLInvItemsSubCategory.GetItemSubCategoryList(itemsCategory.ItemsCategoryID, itemsCategory.Active);
lstitemCategoryList.Add(itemsCategory);
}
return(lstitemCategoryList);
}
catch (Exception ex)
{
throw new Exception("Error occur while selecting Item Category" + ex.Message);
}
}
public static bool AddUpdateItemCategory(ATTInvItemsCategory itemsCategory)
{
try
{
return(DLLInvItemsCategory.AddUpdateItemCategory(itemsCategory));
}
catch (Exception ex)
{
throw new Exception("Error occur while adding and updating ItemCategory" + ex.Message);
}
}
protected void grdItemSubCategory_SelectedIndexChanged(object sender, EventArgs e)
{
ATTInvItemsCategory obj = (ATTInvItemsCategory)Session["ItemCategory"];
List <ATTInvItemSubCategory> itemsSubCategory = obj.LstItemSubCategory;
string chkd = itemsSubCategory[grdItemSubCategory.SelectedIndex].Active;
this.txSubCategory_Rqd.Text = itemsSubCategory[this.grdItemSubCategory.SelectedIndex].ItemsSubCategoryName;
chkISCActive.Checked = (chkd == "Y") ? true : false;
itemsSubCategory[grdItemSubCategory.SelectedIndex].Action = (itemsSubCategory[grdItemSubCategory.SelectedIndex].Action == "A" ? "A" : "E");
}
private void LoadCategory()
{
List <ATTInvItemsCategory> lst = BLLInvItemsCategory.GetItemCategoryList(null, null);
ATTInvItemsCategory obj = new ATTInvItemsCategory();
obj.ItemsCategoryName = "----छान्नुहोस----";
obj.ItemsCategoryID = -1;
lst.Insert(0, obj);
ddlCategory.DataSource = lst;
ddlCategory.DataBind();
}
void ClearitemCategory()
{
this.lstItemCategory.SelectedIndex = -1;
this.txtItemCategoryName_Rqd.Text = "";
this.chkICActive.Checked = true;
this.grdItemSubCategory.SelectedIndex = -1;
this.grdItemSubCategory.DataSource = "";
grdItemSubCategory.DataBind();
this.txSubCategory_Rqd.Text = "";
this.chkISCActive.Checked = true;
this.lblStatus.Text = "";
LoadItemCategoryList();
Session["ItemCategory"] = new ATTInvItemsCategory();
}
public static bool AddUpdateItemCategory(ATTInvItemsCategory itemsCategory)
{
string sp = "";
if (itemsCategory.Action == "A")
{
sp = "sp_inv_add_items_category";
}
else if (itemsCategory.Action == "E")
{
sp = "sp_inv_edit_items_category";
}
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam(":p_items_category_id", itemsCategory.ItemsCategoryID, OracleDbType.Int64, System.Data.ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam(":p_items_category_name", itemsCategory.ItemsCategoryName, OracleDbType.Varchar2, System.Data.ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_active", itemsCategory.Active, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_entry_by", itemsCategory.EntryBy, OracleDbType.Varchar2, System.Data.ParameterDirection.Input));
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.OAS).BeginTransaction();
try
{
SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, sp, paramArray.ToArray());
itemsCategory.ItemsCategoryID = int.Parse(paramArray[0].Value.ToString());
DLLInvItemSubCategory.AddUpdateDeleteItemSubCategory(itemsCategory.LstItemSubCategory, itemsCategory.ItemsCategoryID, Tran);
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
protected void grdItemSubCategory_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int i = e.RowIndex;
ATTInvItemsCategory itemsCategory = (ATTInvItemsCategory)Session["ItemCategory"];
List <ATTInvItemSubCategory> itemSubCategory = itemsCategory.LstItemSubCategory;
if ((itemSubCategory[i].Action == null) || (itemSubCategory[i].Action == "E"))
{
itemSubCategory[i].Action = "D";
}
else if (itemSubCategory[i].Action == "D")
{
itemSubCategory[i].Action = "E";
}
else if (itemSubCategory[i].Action == "A")
{
itemSubCategory.RemoveAt(i);
}
this.grdItemSubCategory.DataSource = itemSubCategory;
this.grdItemSubCategory.DataBind();
this.grdItemSubCategory.SelectedIndex = -1;
SetGridColor(4, 6, this.grdItemSubCategory);
}
private void LoadItemCategory()
{
try
{
List <ATTInvItemsCategory> lstItemCategory = BLLInvItemsCategory.GetItemCategoryList(null, null);
ATTInvItemsCategory obj = new ATTInvItemsCategory();
obj.ItemsCategoryID = -5;
obj.ItemsCategoryName = "--- छान्नुहोस् ---";
lstItemCategory.Insert(0, obj);
Session["Item_ItemCategory"] = lstItemCategory;
this.DDLItemCategory.DataSource = lstItemCategory;
this.DDLItemCategory.DataTextField = "ItemsCategoryName";
this.DDLItemCategory.DataValueField = "ItemsCategoryID";
this.DDLItemCategory.DataBind();
}
catch (Exception ex)
{
this.lblStatus.Text = ex.Message;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.txtItemCategoryName_Rqd.Text == "")
{
this.lblStatusMessage.Text = "Please enter item category name.";
this.programmaticModalPopup.Show();
this.lblStatus.Focus();
return;
}
ATTInvItemsCategory itemsCategory = (ATTInvItemsCategory)Session["ItemCategory"];
List <ATTInvItemsCategory> lstall = (List <ATTInvItemsCategory>)Session["ItemCategory_List"];
if (lstItemCategory.SelectedIndex == -1)
{
bool Exists = lstall.Exists(
delegate(ATTInvItemsCategory ob)
{
return(ob.ItemsCategoryName == txtItemCategoryName_Rqd.Text);
}
);
if (Exists)
{
this.lblStatusMessage.Text = "Item category name already exists";
this.programmaticModalPopup.Show();
return;
}
else
{
int count = 0;
foreach (ATTInvItemSubCategory varNew in itemsCategory.LstItemSubCategory)
{
foreach (ATTInvItemsCategory var in lstall)
{
int index = var.LstItemSubCategory.FindIndex(
delegate(ATTInvItemSubCategory ob)
{
return(ob.ItemsSubCategoryName == varNew.ItemsSubCategoryName);
}
);
if (index >= 0)
{
count++;
}
}
}
if (count > 0)
{
this.lblStatusMessage.Text = "Already Exists";
this.programmaticModalPopup.Show();
return;
}
else
{
itemsCategory.Active = (chkICActive.Checked ? "Y" : "N");
itemsCategory.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
itemsCategory.ItemsCategoryName = txtItemCategoryName_Rqd.Text;
if (lstItemCategory.SelectedIndex >= 0)
{
itemsCategory.Action = "E";
}
else
{
itemsCategory.Action = "A";
}
if (BLLInvItemsCategory.AddUpdateItemCategory(itemsCategory))
{
this.lblStatusMessage.Text = "Information Saved";
this.programmaticModalPopup.Show();
}
else
{
this.lblStatusMessage.Text = "Information could not be Saved";
this.programmaticModalPopup.Show();
}
}
}
}
else
{
bool valid = true;
int indx = lstall.FindIndex(
delegate(ATTInvItemsCategory ob)
{
return(ob.ItemsCategoryName == txtItemCategoryName_Rqd.Text);
}
);
if (indx > 0)
{
if (indx != lstItemCategory.SelectedIndex)
{
valid = false;
}
}
if (!valid)
{
this.lblStatusMessage.Text = "Item category name already exists";
this.programmaticModalPopup.Show();
return;
}
else
{
int count = 0;
foreach (ATTInvItemSubCategory varNew in itemsCategory.LstItemSubCategory)
{
for (int i = 0; i < lstall.Count; i++)
{
if (i != lstItemCategory.SelectedIndex)
{
int index = lstall[i].LstItemSubCategory.FindIndex(
delegate(ATTInvItemSubCategory ob)
{
return(ob.ItemsSubCategoryName == varNew.ItemsSubCategoryName);
}
);
if (index >= 0)
{
count++;
}
}
}
}
if (count > 0)
{
this.lblStatusMessage.Text = "Already Exists";
this.programmaticModalPopup.Show();
return;
}
else
{
itemsCategory.Active = (chkICActive.Checked ? "Y" : "N");
itemsCategory.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
itemsCategory.ItemsCategoryName = txtItemCategoryName_Rqd.Text;
if (lstItemCategory.SelectedIndex >= 0)
{
itemsCategory.Action = "E";
}
else
{
itemsCategory.Action = "A";
}
if (BLLInvItemsCategory.AddUpdateItemCategory(itemsCategory))
{
this.lblStatusMessage.Text = "Information Saved";
this.programmaticModalPopup.Show();
}
else
{
this.lblStatusMessage.Text = "Information could not be Saved";
this.programmaticModalPopup.Show();
}
}
}
}
ClearitemCategory();
}
protected void btnAddItemSubCategory_Click(object sender, EventArgs e)
{
if (this.txSubCategory_Rqd.Text == "")
{
return;
}
//////////
ATTInvItemsCategory itemsCategory = (ATTInvItemsCategory)Session["ItemCategory"];
List <ATTInvItemsCategory> lstall = (List <ATTInvItemsCategory>)Session["ItemCategory_List"];
if (lstItemCategory.SelectedIndex == -1)
{
foreach (ATTInvItemsCategory var in lstall)
{
int index = var.LstItemSubCategory.FindIndex(
delegate(ATTInvItemSubCategory ob)
{
return(ob.ItemsSubCategoryName == txSubCategory_Rqd.Text);
}
);
if (index >= 0)
{
this.lblStatusMessage.Text = "Item SubCategory Already Exists";
this.programmaticModalPopup.Show();
return;
}
else
{
if (grdItemSubCategory.SelectedIndex < 0)
{
if (itemsCategory.LstItemSubCategory.Exists(
delegate(ATTInvItemSubCategory ob)
{
return(ob.ItemsSubCategoryName == txSubCategory_Rqd.Text);
}
))
{
this.lblStatusMessage.Text = "Item SubCategory Already Exists";
this.programmaticModalPopup.Show();
return;
}
}
else
{
int ind = itemsCategory.LstItemSubCategory.FindIndex(
delegate(ATTInvItemSubCategory ob)
{
return(ob.ItemsSubCategoryName == txSubCategory_Rqd.Text);
}
);
if (ind >= 0)
{
if (ind != grdItemSubCategory.SelectedIndex)
{
this.lblStatusMessage.Text = "Item SubCategory Already Exists";
this.programmaticModalPopup.Show();
return;
}
}
}
}
}
}
else
{
int index = -1;
for (int i = 0; i < lstall.Count; i++)
{
if (i != lstItemCategory.SelectedIndex)
{
index = lstall[i].LstItemSubCategory.FindIndex(
delegate(ATTInvItemSubCategory ob)
{
return(ob.ItemsSubCategoryName == txSubCategory_Rqd.Text);
}
);
}
if (index >= 0)
{
this.lblStatusMessage.Text = "Item SubCategory Already Exists";
this.programmaticModalPopup.Show();
return;
}
else
{
if (grdItemSubCategory.SelectedIndex < 0)
{
if (itemsCategory.LstItemSubCategory.Exists(
delegate(ATTInvItemSubCategory ob)
{
return(ob.ItemsSubCategoryName == txSubCategory_Rqd.Text);
}
))
{
this.lblStatusMessage.Text = "Item SubCategory Already Exists";
this.programmaticModalPopup.Show();
return;
}
}
else
{
int ind = itemsCategory.LstItemSubCategory.FindIndex(
delegate(ATTInvItemSubCategory ob)
{
return(ob.ItemsSubCategoryName == txSubCategory_Rqd.Text);
}
);
if (ind >= 0)
{
if (ind != grdItemSubCategory.SelectedIndex)
{
this.lblStatusMessage.Text = "Item SubCategory Already Exists";
this.programmaticModalPopup.Show();
return;
}
}
}
}
}
}
//////////
ATTInvItemsCategory obj = (ATTInvItemsCategory)Session["ItemCategory"];
if (grdItemSubCategory.SelectedIndex > -1)
{
obj.LstItemSubCategory[grdItemSubCategory.SelectedIndex].ItemsSubCategoryName = txSubCategory_Rqd.Text;
obj.LstItemSubCategory[grdItemSubCategory.SelectedIndex].Active = (chkISCActive.Checked == true ? "Y" : "N");
obj.LstItemSubCategory[grdItemSubCategory.SelectedIndex].Action = (obj.LstItemSubCategory[grdItemSubCategory.SelectedIndex].Action == "A" ? "A" : "E");
obj.LstItemSubCategory[grdItemSubCategory.SelectedIndex].EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
}
else
{
ATTInvItemSubCategory ob = new ATTInvItemSubCategory();
ob.ItemsSubCategoryName = txSubCategory_Rqd.Text;
ob.Active = chkISCActive.Checked == true ? "Y" : "N";
ob.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
ob.Action = "A";
obj.LstItemSubCategory.Add(ob);
this.grdItemSubCategory.SelectedIndex = -1;
this.txSubCategory_Rqd.Text = "";
this.chkISCActive.Checked = true;
}
grdItemSubCategory.DataSource = obj.LstItemSubCategory;
grdItemSubCategory.DataBind();
grdItemSubCategory.SelectedIndex = -1;
txSubCategory_Rqd.Text = "";
this.chkISCActive.Checked = true;
}
