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