protected void SaveCity(object sender, EventArgs e)
{
try
{
if (ddlState.SelectedValue == null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Select State')", true);
}
else
{
con.Open();
SqlTransaction trans = con.BeginTransaction(IsolationLevel.ReadCommitted);
string qry = "";
qry = "select MAX(City_Code) as City_Code from SPCN_City_Master ";
SqlCommand cmd = new SqlCommand();
cmd = new SqlCommand(qry, con);
cmd.Transaction = trans;
cmd.Clone();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
objML_Masters.ID = dr["City_Code"].ToString();
}
if (clsCommon.myLen(objML_Masters.ID) <= 0)
{
objML_Masters.ID = "City0000001";
}
else
{
objML_Masters.ID = clsCommon.incval(objML_Masters.ID);
}
con.Close();
objML_Masters.StateName = ddlState.SelectedValue != "" ? ddlState.SelectedValue : null;
objML_Masters.CityName = txtCity.Text != "" ? txtCity.Text : null;
objML_Masters.CreatedBy = Session["UserName"].ToString();
objML_Masters.ModifyBy = Session["UserName"].ToString();
int x = objBL_Masters.BL_SaveCityMaster(objML_Masters);
if (x == 1)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Data Saved !')", true);
CityClear(sender, e);
BindStateMaster();
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('" + ex.Message.ToString() + "')", true);
}
}
