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