/// <summary> /// Insert GdsAirportDal detail. /// </summary> /// <param name="xmlData">Data that converted into xml format.</param> /// <returns>Returns 1 and 0; (1 indicates successful operation).</returns> public int UpdateRegionCountryMap(CountryRegionMapBDto CountryRegionMapBDto) { Database db = null; DbCommand dbCmd = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand("USP_COMMON_COUNTRY_REGION_MAP_UPDATE"); db.AddInParameter(dbCmd, "@SR_NO", DbType.Int32, CountryRegionMapBDto.SrNO); db.AddInParameter(dbCmd, "@REGION_ID", DbType.Int32, CountryRegionMapBDto.RegionId); db.AddInParameter(dbCmd, "@COUNTRY_ID", DbType.Int32, CountryRegionMapBDto.CountryId); Result = db.ExecuteNonQuery(dbCmd); } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } finally { DALHelper.Destroy(ref dbCmd); } return Result; }
private void Update() { try { int result = 0; CountryRegionMapDal = new CountryRegionMapDal(); bool IsInsert = false; CountryRegionMapBDto = new CountryRegionMapBDto(); if (ViewState["SrNo"] != null) { CountryRegionMapBDto.SrNO = Convert.ToInt32(ViewState["SrNo"]); } if (radAirline.SelectedValue != "0") CountryRegionMapBDto.RegionId = Convert.ToInt32(radAirline.SelectedValue); if (radCmbDestination.SelectedValue != "0") CountryRegionMapBDto.CountryId = Convert.ToInt32(radCmbDestination.SelectedValue); result = CountryRegionMapDal.UpdateRegionCountryMap(CountryRegionMapBDto); if (result > 0) { IsInsert = true; } else { IsInsert = false; } if (IsInsert) { Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Update].ToString()); Master.MessageCssClass = "successMessage"; acbGDSCode.SaveButton.CommandName = "Update"; BindGrid(); } else { Master.DisplayMessage(ConfigurationSettings.AppSettings[GeneralMessage.ExistRecord].ToString()); Master.MessageCssClass = "errorMessage"; } } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } }