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