protected void Save(object sender, EventArgs e)
{
try
{
if (txtHotelName.Text == null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Fill Hotel Name')", true);
}
else if (txtEmailID.Text == null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Fill Email ID')", true);
}
else if (txtGSTIN.Text == null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Fill GSTIN No')", true);
}
else
{
con.Open();
SqlTransaction trans = con.BeginTransaction(IsolationLevel.ReadCommitted);
string qry = "";
qry = "select MAX(HOTELID) as HOTELID from SPCN_HOTEL_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["HOTELID"].ToString();
}
if (clsCommon.myLen(objML_Masters.ID) <= 0)
{
objML_Masters.ID = "HOTEL0000001";
}
else
{
objML_Masters.ID = clsCommon.incval(objML_Masters.ID);
}
con.Close();
objML_Masters.Name = txtHotelName.Text != "" ? txtHotelName.Text : null;
objML_Masters.PublishDate = txtHotelCreatedDate.Text != "" ? txtHotelCreatedDate.Text : null;
objML_Masters.Address = txtAddress.Text != "" ? txtAddress.Text : null;
objML_Masters.State = ddlState.SelectedValue != "" ? ddlState.SelectedValue : null;
objML_Masters.City = ddlcity.SelectedValue != "" ? ddlcity.SelectedValue : null;
objML_Masters.Country = ddlCountry.SelectedValue != "" ? ddlCountry.SelectedValue : null;
objML_Masters.ZipCode = txtZip.Text != "" ? txtZip.Text : null;
objML_Masters.Website = txtWebSite.Text != "" ? txtWebSite.Text : null;
objML_Masters.EmailID = txtEmailID.Text != "" ? txtEmailID.Text : null;
objML_Masters.Phone1 = txtPhone1.Text != "" ? txtPhone1.Text : null;
objML_Masters.Phone2 = txtPhone2.Text != "" ? txtPhone2.Text : null;
objML_Masters.MobileNo = txtMobile.Text != "" ? txtMobile.Text : null;
objML_Masters.PanNo = txtPanNo.Text != "" ? txtPanNo.Text : null;
objML_Masters.TanNo = txtTanNo.Text != "" ? txtTanNo.Text : null;
objML_Masters.GSTIN = txtGSTIN.Text != "" ? txtGSTIN.Text : null;
objML_Masters.CreatedBy = Session["UserName"].ToString();
objML_Masters.ModifyBy = Session["UserName"].ToString();
int x = objBL_Masters.BL_SaveHotelMaster(objML_Masters);
if (x == 1)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Data Saved !')", true);
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('" + ex.Message.ToString() + "')", true);
}
}