protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e)
{
cmdMode = CommandMode.D;
objState = new Store.State.BusinessObject.State();
oblState = new Store.State.BusinessLogic.State();
try
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
objState.StateID = Convert.ToInt32(dgvState.DataKeys[gvrow.RowIndex].Value.ToString());
objState.StateName = "";
//objState.CreatedBy = Convert.ToInt32(Session["UserId"].ToString());
objMessageInfo = oblState.ManageItemMaster(objState, cmdMode);
BindState();
updateStateBdInfo.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(State).FullName, 1);
}
finally
{
objState = null;
objMessageInfo = null;
oblState = null;
}
}
void ManageState()
{
objState = new Store.State.BusinessObject.State();
oblState = new Store.State.BusinessLogic.State();
try
{
if (cmdMode == Store.Common.CommandMode.M)
{
objState.StateID = Convert.ToInt32(txtStateId.Text);
//objState.ModifiedBy = Convert.ToInt32(Session["UserId"].ToString());
}
else
{
objState.StateID = 0;
//objState.CreatedBy = Convert.ToInt32(Session["UserId"].ToString());
}
objState.StateName = Convert.ToString(txtState.Text);
objState.CountryID = Convert.ToInt32(ddlCountry.SelectedItem.Value);
//objState.CreatedBy = Convert.ToInt32(Session["UserId"].ToString());
objMessageInfo = oblState.ManageItemMaster(objState, cmdMode);
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(State).FullName, 1);
}
finally
{
objState = null;
//objMessageInfo = null;
oblState = null;
}
}
public Store.State.BusinessObject.State GetAllState(int StateID, int Flag, string FlagValue)
{
Store.State.BusinessObject.State objState = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "";
paramList.Add(new SQLParameter("@StateID", StateID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
if (dr.IsDBNull(dr.GetOrdinal("StateID")) == false)
{
objState.StateID = dr.GetInt32(dr.GetOrdinal("StateID"));
}
if (dr.IsDBNull(dr.GetOrdinal("StateName")) == false)
{
objState.StateName = dr.GetString(dr.GetOrdinal("StateName"));
}
if (dr.IsDBNull(dr.GetOrdinal("CountryID")) == false)
{
objState.CountryID = dr.GetInt32(dr.GetOrdinal("CountryID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)
{
objState.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)
{
objState.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)
{
objState.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)
{
objState.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)
{
objState.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));
}
}
dr.Close();
return(objState);
}
catch (Exception ex)
{
throw;
}
}
public Store.Common.MessageInfo ManageItemMaster(Store.State.BusinessObject.State objState, CommandMode cmdMode)
{
try
{
return(oblState.ManageState(objState, cmdMode));
}
catch (Exception ex)
{
throw;
}
}
public Store.Common.MessageInfo ManageState(Store.State.BusinessObject.State objState, CommandMode cmdMode)
{
string SQL = "USP_ManageState";
ParameterList paramList = new ParameterList();
DataTableReader dr;
Store.Common.MessageInfo objMessageInfo = null;
try
{
paramList.Add(new SQLParameter("@StateID", objState.StateID));
paramList.Add(new SQLParameter("@StateName", objState.StateName));
paramList.Add(new SQLParameter("@CountryID", objState.CountryID));
if (cmdMode == CommandMode.N)
{
paramList.Add(new SQLParameter("@UserId", objState.CreatedBy));
}
else
{
paramList.Add(new SQLParameter("@UserId", objState.ModifiedBy));
}
paramList.Add(new SQLParameter("@ReferenceID", objState.ReferenceID));
paramList.Add(new SQLParameter("@CMDMode", cmdMode));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
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"]);
}
return(objMessageInfo);
}
catch (Exception ex)
{
throw;
}
}
