protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e) { cmdMode = CommandMode.D; objTypeOfVendor = new Store.TypeOfVendor.BusinessObject.TypeOfVendor(); oblTypeOfVendor = new Store.TypeOfVendor.BusinessLogic.TypeOfVendor(); try { ImageButton btndetails = sender as ImageButton; GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer; objTypeOfVendor.TypeofVendorID = Convert.ToInt32(dgvTypeofVendor.DataKeys[gvrow.RowIndex].Value.ToString()); objTypeOfVendor.TypeofVendorName = ""; objTypeOfVendor.CreatedBy = 1; objMessageInfo = oblTypeOfVendor.ManageItemMaster(objTypeOfVendor, cmdMode); BindTypeOfVendor(); updateTypeofUserBdInfo.Update(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('" + objMessageInfo.TranMessage + "')", true); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(TypeOfVendor).FullName, 1); } finally { objTypeOfVendor = null; objMessageInfo = null; oblTypeOfVendor = null; } }
void ManageTypeOfVendor() { objTypeOfVendor = new Store.TypeOfVendor.BusinessObject.TypeOfVendor(); oblTypeOfVendor = new Store.TypeOfVendor.BusinessLogic.TypeOfVendor(); try { if (cmdMode == Store.Common.CommandMode.M) { objTypeOfVendor.TypeofVendorID = Convert.ToInt32(txtTypeofVendorId.Text); //objTypeOfUser.ModifiedBy = Convert.ToInt32(Session["UserId"]); } else { objTypeOfVendor.TypeofVendorID = 0; //objTypeOfUser.CreatedBy = Convert.ToInt32(Session["UserId"]); } objTypeOfVendor.TypeofVendorName = Convert.ToString(txtTypeofVendorName.Text); objMessageInfo = oblTypeOfVendor.ManageItemMaster(objTypeOfVendor, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(TypeOfVendor).FullName, 1); } finally { objTypeOfVendor = null; //objMessageInfo = null; oblTypeOfVendor = null; } }
public Store.TypeOfVendor.BusinessObject.TypeOfVendor GetAllTypeOfVendor(int TypeofVendorID, int Flag, string FlagValue) { Store.TypeOfVendor.BusinessObject.TypeOfVendor objTypeOfVendor = null; string SQL = string.Empty; ParameterList paramList = new ParameterList(); DataTableReader dr; try { SQL = "proc_TypeOfVendor"; paramList.Add(new SQLParameter("@TypeofVendorID", TypeofVendorID)); paramList.Add(new SQLParameter("@Flag", Flag)); paramList.Add(new SQLParameter("@FlagValue", Flag)); dr = ExecuteQuery.ExecuteReader(SQL, paramList); while (dr.Read()) { objTypeOfVendor = new BusinessObject.TypeOfVendor(); if (dr.IsDBNull(dr.GetOrdinal("TypeofVendorID")) == false) { objTypeOfVendor.TypeofVendorID = dr.GetInt32(dr.GetOrdinal("TypeofVendorID")); } if ((dr.IsDBNull(dr.GetOrdinal("TypeofVendorName")) == false)) { objTypeOfVendor.TypeofVendorName = dr.GetString(dr.GetOrdinal("TypeofVendorName")); } if ((dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)) { objTypeOfVendor.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID")); } if ((dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)) { objTypeOfVendor.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn")); } if ((dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)) { objTypeOfVendor.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy")); } if ((dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)) { objTypeOfVendor.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy")); } if ((dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)) { objTypeOfVendor.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn")); } if ((dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)) { objTypeOfVendor.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(TypeOfVendor).FullName, 1); } return(objTypeOfVendor); }
public Store.Common.MessageInfo ManageItemMaster(Store.TypeOfVendor.BusinessObject.TypeOfVendor objTypeOfVendor, CommandMode cmdMode) { try { return(odlTypeOfVendor.ManageTypeOfVendor(objTypeOfVendor, cmdMode)); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(TypeOfVendor).FullName, 1); return(null); } }
public Store.Common.MessageInfo ManageTypeOfVendor(Store.TypeOfVendor.BusinessObject.TypeOfVendor objTypeOfVendor, CommandMode cmdMode) { string SQL = ""; ParameterList param = new ParameterList(); DataTableReader dr; Store.Common.MessageInfo objMessageInfo = null; try { SQL = "USP_ManageTypeOfVendor"; param.Add(new SQLParameter("@TypeofVendorID", objTypeOfVendor.TypeofVendorID)); param.Add(new SQLParameter("@TypeofVendorName", objTypeOfVendor.TypeofVendorName)); if (cmdMode == CommandMode.N) { param.Add(new SQLParameter("@UserId", objTypeOfVendor.CreatedBy)); } else { param.Add(new SQLParameter("@UserId", objTypeOfVendor.ModifiedBy)); } param.Add(new SQLParameter("@ReferenceID", objTypeOfVendor.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(TypeOfVendor).FullName, 1); } return(objMessageInfo); }