private void FillStateCode(int CountryCode)
{
try
{
tbl_StateMasterProp Objtbl_StateMasterProp = new tbl_StateMasterProp();
Objtbl_StateMasterProp.CountryCode = CountryCode;
tbl_StateMasterBAL Objtbl_StateMasterBAL = new tbl_StateMasterBAL();
DataSet dsData = Objtbl_StateMasterBAL.SelectCombo_Data(Objtbl_StateMasterProp);
DataRow dr = dsData.Tables[0].NewRow();
dr["StateName"] = "--- Select Any ---";
dr["StateCode"] = 0;
dsData.Tables[0].Rows.InsertAt(dr, 0);
ddlStateCode.DataSource = dsData.Tables[0];
ddlStateCode.DataTextField = "StateName";
ddlStateCode.DataValueField = "StateCode";
ddlStateCode.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_Data(tbl_StateMasterProp Objtbl_StateMasterProp)
{
try
{
tbl_StateMasterDAL Objtbl_StateMasterDAL = new tbl_StateMasterDAL();
return(Objtbl_StateMasterDAL.Delete_Data(Objtbl_StateMasterProp));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet SelectCombo_Data(tbl_StateMasterProp Objtbl_StateMasterProp)
{
try
{
tbl_StateMasterDAL Objtbl_StateMasterDAL = new tbl_StateMasterDAL();
return(Objtbl_StateMasterDAL.SelectCombo_Data(Objtbl_StateMasterProp));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet SelectCombo_Data(tbl_StateMasterProp Objtbl_StateMasterProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("SelectCombo_tbl_StateMaster");
DB.AddInParameter(DBCmd, "@CountryCode", DbType.Int32, Objtbl_StateMasterProp.CountryCode);
return(DB.ExecuteDataSet(DBCmd));
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_Data(tbl_StateMasterProp Objtbl_StateMasterProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("Delete_tbl_StateMaster");
DB.AddInParameter(DBCmd, "@StateCode", DbType.Int32, Objtbl_StateMasterProp.StateCode);
return(DB.ExecuteNonQuery(DBCmd));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Search_Data(tbl_StateMasterProp Objtbl_StateMasterProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("Search_tbl_StateMaster");
DB.AddInParameter(DBCmd, "@SearchBy", DbType.String, Objtbl_StateMasterProp.SearchBy);
DB.AddInParameter(DBCmd, "@SearchVal", DbType.String, Objtbl_StateMasterProp.SearchVal);
return(DB.ExecuteDataSet(DBCmd));
}
catch (Exception ex)
{
throw ex;
}
}
private void DeleteData(int StateCode)
{
try
{
tbl_StateMasterProp Objtbl_StateMasterProp = new tbl_StateMasterProp();
Objtbl_StateMasterProp.StateCode = StateCode;
tbl_StateMasterBAL Objtbl_StateMasterBAL = new tbl_StateMasterBAL();
Objtbl_StateMasterBAL.Delete_Data(Objtbl_StateMasterProp);
FillData();
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertUpdate_Data(tbl_StateMasterProp Objtbl_StateMasterProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("InsertUpdate_tbl_StateMaster");
DB.AddInParameter(DBCmd, "@StateCode", DbType.Int32, Objtbl_StateMasterProp.StateCode);
DB.AddInParameter(DBCmd, "@StateName", DbType.String, Objtbl_StateMasterProp.StateName);
DB.AddInParameter(DBCmd, "@CountryCode", DbType.Int32, Objtbl_StateMasterProp.CountryCode);
DB.AddOutParameter(DBCmd, "@RetVal", DbType.Int32, 18);
DB.ExecuteNonQuery(DBCmd);
return(Convert.ToInt32(DBCmd.Parameters["@RetVal"].Value));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Select_Data(tbl_StateMasterProp Objtbl_StateMasterProp, ref int TotalCount)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("Select_tbl_StateMaster");
DB.AddInParameter(DBCmd, "@StateCode", DbType.Int32, Objtbl_StateMasterProp.StateCode);
DB.AddInParameter(DBCmd, "@PageNo", DbType.Int32, Objtbl_StateMasterProp.PageNo);
DB.AddInParameter(DBCmd, "@RecordCount", DbType.Int32, Objtbl_StateMasterProp.RecordCount);
DB.AddOutParameter(DBCmd, "@TotalCount", DbType.Int32, 18);
DataSet dsData = DB.ExecuteDataSet(DBCmd);
TotalCount = Convert.ToInt32(DBCmd.Parameters["@TotalCount"].Value);
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
private void EditData(int StateCode)
{
try
{
tbl_StateMasterProp Objtbl_StateMasterProp = new tbl_StateMasterProp();
Objtbl_StateMasterProp.StateCode = StateCode;
int PageCount = 0;
tbl_StateMasterBAL Objtbl_StateMasterBAL = new tbl_StateMasterBAL();
DataSet dsData = Objtbl_StateMasterBAL.Select_Data(Objtbl_StateMasterProp, ref PageCount);
txtStateName.Text = Convert.ToString(dsData.Tables[0].Rows[0]["StateName"]);
ddlCountryCode.SelectedValue = Convert.ToString(dsData.Tables[0].Rows[0]["CountryCode"]);
ViewState["EditCode"] = StateCode;
}
catch (Exception ex)
{
throw ex;
}
}
protected void imgbtnSave_Click(object sender, ImageClickEventArgs e)
{
try
{
tbl_StateMasterProp Objtbl_StateMasterProp = new tbl_StateMasterProp();
Objtbl_StateMasterProp.StateCode = Convert.ToInt32(ViewState["EditCode"]);
Objtbl_StateMasterProp.StateName = txtStateName.Text;
Objtbl_StateMasterProp.CountryCode = Convert.ToInt32(ddlCountryCode.SelectedValue);
tbl_StateMasterBAL Objtbl_StateMasterBAL = new tbl_StateMasterBAL();
Objtbl_StateMasterBAL.InsertUpdate_Data(Objtbl_StateMasterProp);
ShowGuidMessage(1, null);
mdlPopupNewEntry.Hide();
FillData();
}
catch (Exception ex)
{
ShowGuidMessage(0, ex); //MessageBox.Show(ex.Message);
}
}
private void FillData()
{
try
{
int PageCount = 0;
tbl_StateMasterProp Objtbl_StateMasterProp = new tbl_StateMasterProp();
Objtbl_StateMasterProp.StateCode = 0;
Objtbl_StateMasterProp.PageNo = Convert.ToInt32(txtCurPage.Text);
Objtbl_StateMasterProp.RecordCount = Convert.ToInt32(20);
tbl_StateMasterBAL Objtbl_StateMasterBAL = new tbl_StateMasterBAL();
DataSet dsData = Objtbl_StateMasterBAL.Select_Data(Objtbl_StateMasterProp, ref PageCount);
lblTotalPage.Text = Convert.ToString(PageCount);
grdData.DataSource = dsData.Tables[0];
grdData.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Select_Data(tbl_StateMasterProp Objtbl_StateMasterProp, ref int PageCount)
{
try
{
if (Objtbl_StateMasterProp.StateCode != 0)
{
Objtbl_StateMasterProp.PageNo = 1;
Objtbl_StateMasterProp.RecordCount = 1;
}
int RecordCount = 0;
tbl_StateMasterDAL Objtbl_StateMasterDAL = new tbl_StateMasterDAL();
DataSet dsData = Objtbl_StateMasterDAL.Select_Data(Objtbl_StateMasterProp, ref RecordCount);
double Page = Convert.ToDouble(RecordCount) / Convert.ToDouble(Objtbl_StateMasterProp.RecordCount);
if (dsData.Tables[0].Rows.Count > 0)
{
string[] PageDecimal = Page.ToString().Split('.');
if (PageDecimal.Length > 1 && Convert.ToInt32(PageDecimal[1]) > 0)
{
PageCount = Convert.ToInt32(Page.ToString().Split('.')[0]) + 1;
}
else
{
PageCount = Convert.ToInt32(Page);
}
}
else
{
PageCount = 0;
}
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
