protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e) { cmdMode = CommandMode.D; objCategory = new Store.Category.BusinessObject.Category(); oblCategory = new Store.Category.BusinessLogic.Category(); try { ImageButton btndetails = sender as ImageButton; GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer; objCategory.CategoryID = Convert.ToInt32(dgvCategory.DataKeys[gvrow.RowIndex].Value.ToString()); objCategory.CategoryName = ""; objCategory.CreatedBy = 1; objMessageInfo = oblCategory.ManageItemMaster(objCategory, cmdMode); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('" + objMessageInfo.TranMessage + "')", true); BindCategory(); updateCategoryBdInfo.Update(); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Category).FullName, 1); } finally { objCategory = null; objMessageInfo = null; oblCategory = null; } }
public Store.Common.MessageInfo ManageItemMaster(Store.Category.BusinessObject.Category objCategory, CommandMode cmdMode) { try { return(odlCategory.ManageCategory(objCategory, cmdMode)); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Category).FullName, 1); return(null); } }
public Store.Common.MessageInfo ManageCategory(Store.Category.BusinessObject.Category objCategory, CommandMode cmdMode) { string SQL = ""; ParameterList param = new ParameterList(); DataTableReader dr; Store.Common.MessageInfo objMessageInfo = null; try { SQL = "USP_ManageCategory"; param.Add(new SQLParameter("@CategoryI", objCategory.CategoryID)); param.Add(new SQLParameter("@CategoryName", objCategory.CategoryName)); param.Add(new SQLParameter("@ParentCategoryID", objCategory.ParentCategoryID)); if (cmdMode == CommandMode.N) { param.Add(new SQLParameter("@UserId", objCategory.CreatedBy)); } else { param.Add(new SQLParameter("@UserId", objCategory.ModifiedBy)); } param.Add(new SQLParameter("@ReferenceID", objCategory.ReferenceID)); param.Add(new SQLParameter("@CMDMode", cmdMode)); dr = ExecuteQuery.ExecuteReader(SQL, param); if (dr.Read()) { objMessageInfo = new Store.Common.MessageInfo(); objMessageInfo.ErrorCode = Convert.ToInt32(dr["ErrorCode"]); objMessageInfo.ErrorMessage = Convert.ToString(dr["ErrorMessage"]); objMessageInfo.TranID = Convert.ToInt32(dr["TranID"]); objMessageInfo.TranCode = Convert.ToString(dr["TranCode"]); objMessageInfo.TranMessage = Convert.ToString(dr["TranMessage"]); } } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Category).FullName, 1); } return(objMessageInfo); }
void ManageCategory() { objCategory = new Store.Category.BusinessObject.Category(); oblCategory = new Store.Category.BusinessLogic.Category(); try { if (cmdMode == Store.Common.CommandMode.M) { objCategory.CategoryID = Convert.ToInt32(txtCategoryId.Text); //objCategory.ModifiedBy = Convert.ToInt32(Session["UserId"].ToString()); } else { objCategory.CategoryID = 0; //objCategory.CreatedBy = Convert.ToInt32(Session["UserId"].ToString()); } if (cbParant.Checked) { objCategory.ParentCategoryID = Convert.ToInt32(ddlCategory.SelectedValue); } else { objCategory.ParentCategoryID = 0; } objCategory.CategoryName = Convert.ToString(txtCategoryName.Text); objMessageInfo = oblCategory.ManageItemMaster(objCategory, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Category).FullName, 1); } finally { objCategory = null; oblCategory = null; } }
public Store.Category.BusinessObject.Category GetAllCategory(int CategoryID, int Flag, string FlagValue) { Store.Category.BusinessObject.Category objCategory = null; string SQL = string.Empty; ParameterList paramList = new ParameterList(); DataTableReader dr; try { SQL = "proc_Category"; paramList.Add(new SQLParameter("@CategoryID", CategoryID)); paramList.Add(new SQLParameter("@Flag", Flag)); paramList.Add(new SQLParameter("@FlagValue", Flag)); dr = ExecuteQuery.ExecuteReader(SQL, paramList); while (dr.Read()) { objCategory = new BusinessObject.Category(); if (dr.IsDBNull(dr.GetOrdinal("CategoryID")) == false) { objCategory.CategoryID = dr.GetInt32(dr.GetOrdinal("CategoryID")); } if ((dr.IsDBNull(dr.GetOrdinal("CategoryName")) == false)) { objCategory.CategoryName = dr.GetString(dr.GetOrdinal("CategoryName")); } if ((dr.IsDBNull(dr.GetOrdinal("ParentCategoryID")) == false)) { objCategory.ParentCategoryID = dr.GetInt32(dr.GetOrdinal("ParentCategoryID")); } if ((dr.IsDBNull(dr.GetOrdinal("ParentCategory")) == false)) { objCategory.ParentCategory = dr.GetString(dr.GetOrdinal("ParentCategory")); } if ((dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)) { objCategory.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID")); } if ((dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)) { objCategory.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn")); } if ((dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)) { objCategory.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy")); } if ((dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)) { objCategory.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy")); } if ((dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)) { objCategory.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn")); } if ((dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)) { objCategory.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));; } } dr.Close(); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Category).FullName, 1); } return(objCategory); }