/// <summary>
/// Insert Country Name.
/// </summary>
/// <param name="xmlData">Data that converted into xml format.</param>
/// <returns>Returns 1 and 0; (1 indicates successful operation).</returns>
public int InsertCountryName(GeographicLocationBDto GeographicLocation)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand(DALHelper.USP_ADMINISTRATION_COUNTRY_INSERT);
db.AddInParameter(dbCmd, "@COUNTRY_NAME", DbType.String,GeographicLocation.CountryName);
db.AddInParameter(dbCmd, "@COUNTRY_CODE", DbType.String, GeographicLocation.CountryCode);
db.AddInParameter(dbCmd, "@COUNTRY_CURRENCY_SYMBOL", DbType.String, GeographicLocation.CurrencySymbol);
db.AddInParameter(dbCmd, "@COUNTRY_CURRENCY_NAME", DbType.String, GeographicLocation.CurrencyName);
db.AddInParameter(dbCmd, "@CREATED_BY", DbType.Int32,GeographicLocation.UserProfile.UserId);
db.AddOutParameter(dbCmd, "@ISEXIST", DbType.Int32, 1);
db.ExecuteNonQuery(dbCmd);
Result = Convert.ToInt32(db.GetParameterValue(dbCmd, "@ISEXIST"));
}
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 vwCitySave()
{
try
{
int result = 0;
objGeographicLocation = new GeographicLocationDal();
objGeographicLocationBDto = new GeographicLocationBDto();
objGeographicLocationBDto.CityName = txtCityName.Text;
objGeographicLocationBDto.CountryId = int.Parse(cmbCountryNameCity.SelectedValue);
objGeographicLocationBDto.StateId = int.Parse(cmbStateNameCity.SelectedValue);
objGeographicLocationBDto.UserProfile = objAuthorizationBDto.UserProfile;
result = objGeographicLocation.InsertCity(objGeographicLocationBDto);
if (result >= 1)
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Save].ToString());
Master.MessageCssClass = "successMessage";
}
else
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Save].ToString());
Master.MessageCssClass = "errorMessage";
}
BindGridCity();
Reset();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{ throw ex; }
}
}
///// <summary>
///// Saves checkbox checked status into hashtable after check status changed.
///// </summary>
///// <param name="sender">The object which raised the event</param>
///// <param name="e">The event listener object</param>
//public void chkItemWrt_CheckChanged(object sender, EventArgs e)
//{
// CheckBox chkBox = (CheckBox)sender;
// GridDataItem item = (GridDataItem)chkBox.NamingContainer;
// if ((ViewState[PageConstants.vsItemIndexes] != null))
// {
// htItemIndex = (Hashtable)ViewState[PageConstants.vsItemIndexes];
// }
// else
// {
// htItemIndex = new Hashtable();
// }
// if (chkBox.Checked == true)
// {
// hdnCheckIndex.Value = item.ItemIndex.ToString();
// htItemIndex.Add(htItemIndex.Count, item.ItemIndex);
// item.Selected = true;
// }
// else
// {
// item.Selected = false;
// for (int i = 0; i <= htItemIndex.Count - 1; i++)
// {
// if (htItemIndex[i] != null)
// {
// if (htItemIndex[i].ToString() == item.ItemIndex.ToString())
// {
// radgrdCountry.Items[htItemIndex[i].ToString()].Edit = false;
// htItemIndex.Remove(i);
// break;
// }
// }
// }
// }
// ViewState.Add(PageConstants.vsItemIndexes, htItemIndex);
//}
#endregion
#region Save
#region Save vwCountry
private void vwCountrySave()
{
try
{
int result = 0;
objGeographicLocation = new GeographicLocationDal();
GeographicLocationBDto objGeographicLocationBDto = new GeographicLocationBDto();
objGeographicLocationBDto = new GeographicLocationBDto();
objGeographicLocationBDto.CountryName = txtCountryName.Text;
objGeographicLocationBDto.CountryCode = txtCountryCode.Text;
objGeographicLocationBDto.CurrencySymbol = txtCurrencySymbol.Text;
objGeographicLocationBDto.CurrencyName = txtCurrencyName.Text;
objGeographicLocationBDto.UserProfile = objAuthorizationBDto.UserProfile;
result = objGeographicLocation.InsertCountryName(objGeographicLocationBDto);
if (result >= 1)
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Save].ToString());
Master.MessageCssClass = "successMessage";
}
else
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Save].ToString());
Master.MessageCssClass = "errorMessage";
}
BindGridCountry();
Reset();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{ throw ex; }
}
}