/// <summary> /// Update the TigerReserve /// </summary> /// <param name="tigerReserve"></param> /// <param name="_tigerReserveID"></param> /// <returns></returns> public int UpdateTigerReserve(TigerReserve tigerReserve, int _tigerReserveID) { return(DAL.DataAccess.Instance.ExecuteNonQuery(StoredProcedure.spEditTigerReserve, System.Data.CommandType.StoredProcedure, new List <ICommanParameter> { new CommanParameter { Name = DataBaseFields.TigerReserveId, Type = System.Data.DbType.String, value = _tigerReserveID }, new CommanParameter { Name = DataBaseFields.STATE_ID, Type = System.Data.DbType.String, value = tigerReserve.State }, new CommanParameter { Name = DataBaseFields.District, Type = System.Data.DbType.String, value = tigerReserve.District }, new CommanParameter { Name = DataBaseFields.City, Type = System.Data.DbType.String, value = tigerReserve.City }, new CommanParameter { Name = DataBaseFields.TigerReserveName, Type = System.Data.DbType.String, value = tigerReserve.TigerReserveName }, new CommanParameter { Name = DataBaseFields.CoreArea, Type = System.Data.DbType.String, value = tigerReserve.CoreArea }, new CommanParameter { Name = DataBaseFields.BufferArea, Type = System.Data.DbType.String, value = tigerReserve.BufferArea }, new CommanParameter { Name = DataBaseFields.TotalArea, Type = System.Data.DbType.String, value = tigerReserve.TotalArea }, new CommanParameter { Name = DataBaseFields.DateOfRegistration, Type = System.Data.DbType.String, value = tigerReserve.DateOfRegistration }, new CommanParameter { Name = DataBaseFields.Address, Type = System.Data.DbType.String, value = tigerReserve.Address }, new CommanParameter { Name = DataBaseFields.PinCode, Type = System.Data.DbType.String, value = tigerReserve.PinCode }, new CommanParameter { Name = DataBaseFields.FieldDirector, Type = System.Data.DbType.String, value = tigerReserve.FeildDirector }, new CommanParameter { Name = DataBaseFields.PhoneNumber, Type = System.Data.DbType.String, value = tigerReserve.PhoneNumber }, new CommanParameter { Name = DataBaseFields.AlternatePhoneNumber, Type = System.Data.DbType.String, value = tigerReserve.AlternatePhoneNumber }, new CommanParameter { Name = DataBaseFields.MobileNumber, Type = System.Data.DbType.String, value = tigerReserve.MobileNumber }, new CommanParameter { Name = DataBaseFields.Email, Type = System.Data.DbType.String, value = tigerReserve.Email }, })); }
private void AddNewTigerReserve(TigerReserve tigerReserve) { try { Session.Remove("TigerReserveId"); tigerReserve.State = ddlState.SelectedValue; tigerReserve.District = txtDistrict.Text; tigerReserve.City = txtCity.Text; tigerReserve.TigerReserveName = txtTigerReserve.Text; if (txtCoreArea.Text != "") { tigerReserve.CoreArea = txtCoreArea.Text; } else { tigerReserve.CoreArea = "0.0"; } if (txtBufferArea.Text != "") { tigerReserve.BufferArea = txtBufferArea.Text; } else { tigerReserve.BufferArea = "0.0"; } txtTotalArea.Text = Convert.ToString(Convert.ToDouble(tigerReserve.CoreArea) + Convert.ToDouble(tigerReserve.BufferArea)); tigerReserve.TotalArea = txtTotalArea.Text; tigerReserve.DateOfRegistration = Convert.ToDateTime(txtDOR.Text.ToString()); tigerReserve.Address = txtAddress.Text; tigerReserve.PinCode = txtPinCode.Text; tigerReserve.FeildDirector = txtFieldDirector.Text; tigerReserve.PhoneNumber = txtPhoneNumber.Text; tigerReserve.AlternatePhoneNumber = txtAlternatePhoneNumber.Text; tigerReserve.MobileNumber = txtMobileNumber.Text; tigerReserve.Email = txtEmail.Text; TigerReserveBAL.Instance.AddTigerReserve(tigerReserve); vmSuccess.Message = ConfigurationManager.AppSettings["SaveSuccessMes"].ToString(); FlashMessage.InfoMessage(vmSuccess.Message); Clear(); //Response.Redirect("TigerReserve.aspx", false); } catch (Exception ex) { LogHandler.LogFatal((ex.InnerException != null ? ex.InnerException.Message : ex.Message), ex, this.GetType()); Response.RedirectPermanent("~/ErrorPage.aspx", false); } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (!ValidateCaptcha()) { return; } TigerReserve tr = new TigerReserve(); TigerReserveId = Convert.ToInt32(Session["TigerReserveId"]); if (TigerReserveId != 0) { UpdateTigerReserve(tr, TigerReserveId); txtCaptchaCode.Text = ""; } else { AddNewTigerReserve(tr); Clear(); } }