protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e) { cmdMode = CommandMode.D; objTax = new Store.Tax.BusinessObject.Tax(); oblTax = new Store.Tax.BusinessLogic.Tax(); try { ImageButton btndetails = sender as ImageButton; GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer; objTax.TaxID = Convert.ToInt32(dgvTax.DataKeys[gvrow.RowIndex].Value.ToString()); objTax.TaxName = ""; objTax.TaxDisplayName = ""; objTax.TaxValue = 0; objTax.CreatedBy = 1; objMessageInfo = oblTax.ManageItemMaster(objTax, cmdMode); BindTax(); updateTaxBdInfo.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(Tax).FullName, 1); } finally { objTax = null; objMessageInfo = null; oblTax = null; } }
void ManageTax() { objTax = new Store.Tax.BusinessObject.Tax(); oblTax = new Store.Tax.BusinessLogic.Tax(); try { if (cmdMode == Store.Common.CommandMode.M) { objTax.TaxID = Convert.ToInt32(txtTaxId.Text); //objTax.ModifiedBy = Convert.ToInt32(Session["UserId"]); } else { objTax.TaxID = 0; //objTax.CreatedBy = Convert.ToInt32(Session["UserId"]); } objTax.TaxName = Convert.ToString(txtTaxName.Text); objTax.TaxDisplayName = Convert.ToString(txtTaxDisplayName.Text); objTax.TaxValue = Convert.ToDecimal(txtTaxValue.Text); objMessageInfo = oblTax.ManageItemMaster(objTax, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Tax).FullName, 1); } finally { objTax = null; //objMessageInfo = null; oblTax = null; } }
public Store.Common.MessageInfo ManageItemMaster(Store.Tax.BusinessObject.Tax objTax, CommandMode cmdMode) { try { return(odlTax.ManageTax(objTax, cmdMode)); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Tax).FullName, 1); return(null); } }
public Store.Common.MessageInfo ManageTax(Store.Tax.BusinessObject.Tax objTax, CommandMode cmdMode) { string SQL = ""; ParameterList param = new ParameterList(); DataTableReader dr; Store.Common.MessageInfo objMessageInfo = null; try { SQL = "USP_ManageTax"; param.Add(new SQLParameter("@TaxID", objTax.TaxID)); param.Add(new SQLParameter("@TaxName", objTax.TaxName)); param.Add(new SQLParameter("@TaxDisplayName", objTax.TaxDisplayName)); param.Add(new SQLParameter("@TaxValue", objTax.TaxValue)); if (cmdMode == CommandMode.N) { param.Add(new SQLParameter("@UserId", objTax.CreatedBy)); } else { param.Add(new SQLParameter("@UserId", objTax.ModifiedBy)); } param.Add(new SQLParameter("@ReferenceID", objTax.ReferenceID)); param.Add(new SQLParameter("@CMDMode", cmdMode)); dr = ExecuteQuery.ExecuteReader(SQL, param); if (dr.Read()) { objMessageInfo = new Store.Common.MessageInfo(); //objMessageInfo = new Pareeksha.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(Tax).FullName, 1); } return(objMessageInfo); }
public Store.Tax.BusinessObject.Tax GetAllTax(int TaxID, int Flag, string FlagValue) { Store.Tax.BusinessObject.Tax objTax = null; string SQL = string.Empty; ParameterList paramList = new ParameterList(); DataTableReader dr; try { SQL = "proc_Tax"; paramList.Add(new SQLParameter("@TaxID", TaxID)); paramList.Add(new SQLParameter("@Flag", Flag)); paramList.Add(new SQLParameter("@FlagValue", Flag)); dr = ExecuteQuery.ExecuteReader(SQL, paramList); while (dr.Read()) { objTax = new BusinessObject.Tax(); if (dr.IsDBNull(dr.GetOrdinal("TaxID")) == false) { objTax.TaxID = dr.GetInt32(dr.GetOrdinal("TaxID")); } if ((dr.IsDBNull(dr.GetOrdinal("objTax")) == false)) { objTax.TaxName = dr.GetString(dr.GetOrdinal("TaxName")); } if ((dr.IsDBNull(dr.GetOrdinal("TaxDisplayName")) == false)) { objTax.TaxDisplayName = dr.GetString(dr.GetOrdinal("TaxDispalayName")); } if ((dr.IsDBNull(dr.GetOrdinal("TaxValue")) == false)) { objTax.TaxValue = dr.GetDecimal(dr.GetOrdinal("TaxValue")); } if ((dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)) { objTax.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID")); } if ((dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)) { objTax.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn")); } if ((dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)) { objTax.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy")); } if ((dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)) { objTax.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy")); } if ((dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)) { objTax.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn")); } if ((dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)) { objTax.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(Tax).FullName, 1); } return(objTax); }