private void FillCityCode(int StateCode)
{
try
{
tbl_CityMasterProp Objtbl_CityMasterProp = new tbl_CityMasterProp();
Objtbl_CityMasterProp.StateCode = StateCode;
tbl_CityMasterBAL Objtbl_CityMasterBAL = new tbl_CityMasterBAL();
DataSet dsData = Objtbl_CityMasterBAL.SelectCombo_Data(Objtbl_CityMasterProp);
DataRow dr = dsData.Tables[0].NewRow();
dr["CityName"] = "--- Select Any ---";
dr["CityCode"] = 0;
dsData.Tables[0].Rows.InsertAt(dr, 0);
ddlCityCode.DataSource = dsData.Tables[0];
ddlCityCode.DataTextField = "CityName";
ddlCityCode.DataValueField = "CityCode";
ddlCityCode.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
private void DeleteData(int CityCode)
{
try
{
tbl_CityMasterProp Objtbl_CityMasterProp = new tbl_CityMasterProp();
Objtbl_CityMasterProp.CityCode = CityCode;
tbl_CityMasterBAL Objtbl_CityMasterBAL = new tbl_CityMasterBAL();
Objtbl_CityMasterBAL.Delete_Data(Objtbl_CityMasterProp);
FillData();
}
catch (Exception ex)
{
throw ex;
}
}
private void EditData(int CityCode)
{
try
{
tbl_CityMasterProp Objtbl_CityMasterProp = new tbl_CityMasterProp();
Objtbl_CityMasterProp.CityCode = CityCode;
int PageCount = 0;
tbl_CityMasterBAL Objtbl_CityMasterBAL = new tbl_CityMasterBAL();
DataSet dsData = Objtbl_CityMasterBAL.Select_Data(Objtbl_CityMasterProp, ref PageCount);
txtCityName.Text = Convert.ToString(dsData.Tables[0].Rows[0]["CityName"]);
ddlStateCode.SelectedValue = Convert.ToString(dsData.Tables[0].Rows[0]["StateCode"]);
ViewState["EditCode"] = CityCode;
}
catch (Exception ex)
{
throw ex;
}
}
protected void imgbtnSave_Click(object sender, ImageClickEventArgs e)
{
try
{
tbl_CityMasterProp Objtbl_CityMasterProp = new tbl_CityMasterProp();
Objtbl_CityMasterProp.CityCode = Convert.ToInt32(ViewState["EditCode"]);
Objtbl_CityMasterProp.CityName = txtCityName.Text;
Objtbl_CityMasterProp.StateCode = Convert.ToInt32(ddlStateCode.SelectedValue);
tbl_CityMasterBAL Objtbl_CityMasterBAL = new tbl_CityMasterBAL();
Objtbl_CityMasterBAL.InsertUpdate_Data(Objtbl_CityMasterProp);
ShowGuidMessage(1, null);
mdlPopupNewEntry.Hide();
FillData();
}
catch (Exception ex)
{
ShowGuidMessage(0, ex); //MessageBox.Show(ex.Message);
}
}
private void FillData()
{
try
{
int PageCount = 0;
tbl_CityMasterProp Objtbl_CityMasterProp = new tbl_CityMasterProp();
Objtbl_CityMasterProp.CityCode = 0;
Objtbl_CityMasterProp.PageNo = Convert.ToInt32(txtCurPage.Text);
Objtbl_CityMasterProp.RecordCount = Convert.ToInt32(20);
tbl_CityMasterBAL Objtbl_CityMasterBAL = new tbl_CityMasterBAL();
DataSet dsData = Objtbl_CityMasterBAL.Select_Data(Objtbl_CityMasterProp, ref PageCount);
lblTotalPage.Text = Convert.ToString(PageCount);
grdData.DataSource = dsData.Tables[0];
grdData.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
