protected void acbGeographicLocation_DeleteClick(object sender, EventArgs e)
{
try
{
switch (mvGeographicLocation.GetActiveView().ID.ToLower())
{
case "vwcountry":
StringBuilder CountryId = new StringBuilder();
int result = 0;
if (ViewState[PageConstants.vsItemIndexes] != null)
htItemIndex = (Hashtable)ViewState[PageConstants.vsItemIndexes];
if (htItemIndex != null)
{
foreach (int i in htItemIndex.Values)
{
Label lblCountryId = (Label)radgrdCountry.Items[i].FindControl("lblGrdCountryIdItem");
if (lblCountryId != null)
{
CountryId.Append(lblCountryId.Text + ",");
}
}
}
objGeographicLocation = new GeographicLocationDal();
String ContryId = CountryId.ToString().TrimEnd(',');
result = objGeographicLocation.DeleteCountry(ContryId);
if (result == 1)
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Delete].ToString());
Master.MessageCssClass = "successMessage";
ViewState[PageConstants.vsItemIndexes] = null;
BindGridCountry();
}
else if (result == 547)
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Delete].ToString());
Master.MessageCssClass = "errorMessage";
}
break;
case "vwstate":
StringBuilder StateId = new StringBuilder();
if (ViewState[PageConstants.vsItemIndexes] != null)
htItemIndex = (Hashtable)ViewState[PageConstants.vsItemIndexes];
if (htItemIndex != null)
{
foreach (int i in htItemIndex.Values)
{
Label lblStateId = (Label)radgrdState.Items[i].FindControl("lblGrdStateIdItem");
if (lblStateId != null)
{
StateId.Append(lblStateId.Text + ",");
}
}
}
objGeographicLocation = new GeographicLocationDal();
String StatId = StateId.ToString().TrimEnd(',');
result = objGeographicLocation.DeleteState(StatId);
if (result == 1)
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Delete].ToString());
Master.MessageCssClass = "successMessage";
ViewState[PageConstants.vsItemIndexes] = null;
BindGridState();
}
else if (result == 547)
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Delete].ToString());
Master.MessageCssClass = "errorMessage";
}
break;
case "vwcity":
StringBuilder CityId = new StringBuilder();
if (ViewState[PageConstants.vsItemIndexes] != null)
htItemIndex = (Hashtable)ViewState[PageConstants.vsItemIndexes];
if (htItemIndex != null)
{
foreach (int i in htItemIndex.Values)
{
Label lblCityId = (Label)radgrdCity.Items[i].FindControl("lblGrdCityIdItem");
if (lblCityId != null)
{
CityId.Append(lblCityId.Text + ",");
}
}
}
objGeographicLocation = new GeographicLocationDal();
String CtyId = CityId.ToString().TrimEnd(',');
result = objGeographicLocation.DeleteCity(CtyId);
if (result == 1)
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Delete].ToString());
Master.MessageCssClass = "successMessage";
ViewState[PageConstants.vsItemIndexes] = null;
BindGridCity();
}
else if (result == 547)
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Delete].ToString());
Master.MessageCssClass = "errorMessage";
}
break;
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{ throw ex; }
}
}
protected void acbGeographicLocation_SearchClick(object sender, EventArgs e)
{
try
{
switch (mvGeographicLocation.GetActiveView().ID.ToLower())
{
case "vwcountry":
objGeographicLocation = new GeographicLocationDal();
DataSet dsGeographicCountry = objGeographicLocation.GetCountryName(acbGeographicLocation.SearchTextBox.Text);
radgrdCountry.DataSource = dsGeographicCountry;
radgrdCountry.DataBind();
ViewState[vsGeographicCountry] = dsGeographicCountry;
Reset();
break;
case "vwstate":
objGeographicLocation = new GeographicLocationDal();
DataSet dsGeographicState = objGeographicLocation.GetStateName(acbGeographicLocation.SearchTextBox.Text);
radgrdState.DataSource = dsGeographicState;
radgrdState.DataBind();
ViewState[vsGeographicState] = dsGeographicState;
Reset();
break;
case "vwcity":
objGeographicLocation = new GeographicLocationDal();
DataSet dsGeographicCity = objGeographicLocation.GetCityName(acbGeographicLocation.SearchTextBox.Text);
radgrdCity.DataSource = dsGeographicCity;
radgrdCity.DataBind();
ViewState[vsGeographicCity] = dsGeographicCity;
Reset();
break;
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{ throw ex; }
}
}
protected void acbGeographicLocation_SaveClick(object sender, EventArgs e)
{
try
{
int result = 0;
objGeographicLocation = new GeographicLocationDal();
switch (acbGeographicLocation.SaveButton.CommandName)
{
case "Save":
switch (mvGeographicLocation.GetActiveView().ID.ToLower())
{
case "vwcountry":
vwCountrySave();
pnlAddCountry.Visible = false;
acbGeographicLocation.EditableMode = false;
break;
case "vwstate":
vwStateSave();
pnlAddState.Visible = false;
acbGeographicLocation.EditableMode = false;
break;
case "vwcity":
vwCitySave();
pnlAddCity.Visible = false;
acbGeographicLocation.EditableMode = false;
break;
}
break;
case "Update":
switch (mvGeographicLocation.GetActiveView().ID.ToLower())
{
case "vwcountry":
String xmlDataCountry = GenerateXmlStringCountry(radgrdCountry);
result = objGeographicLocation.UpdateCountry(xmlDataCountry);
if (result == 1)
{
acbGeographicLocation.DefaultMode = true;
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Update].ToString());
Master.MessageCssClass = "successMessage";
if (ViewState[PageConstants.vsItemIndexes] != null)
htItemIndex = (Hashtable)ViewState[PageConstants.vsItemIndexes];
for (int i = 0; i < htItemIndex.Count; i++)
radgrdCountry.Items[Convert.ToInt32(htItemIndex[i])].Edit = false;
bisEdit = false;
ViewState[PageConstants.vsItemIndexes] = null;
BindGridCountry();
}
else
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Update].ToString());
Master.MessageCssClass = "errorMessage";
}
break;
case "vwstate":
String xmlDataState = GenerateXmlStringState(radgrdState);
result = objGeographicLocation.UpdateState(xmlDataState);
if (result == 1)
{
acbGeographicLocation.DefaultMode = true;
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Update].ToString());
Master.MessageCssClass = "successMessage";
if (ViewState[PageConstants.vsItemIndexes] != null)
htItemIndex = (Hashtable)ViewState[PageConstants.vsItemIndexes];
for (int i = 0; i < htItemIndex.Count; i++)
radgrdState.Items[Convert.ToInt32(htItemIndex[i])].Edit = false;
bisEdit = false;
ViewState[PageConstants.vsItemIndexes] = null;
BindGridState();
}
else
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Update].ToString());
Master.MessageCssClass = "errorMessage";
}
break;
case "vwcity":
String xmlDataCity = GenerateXmlStringCity(radgrdCity);
result = objGeographicLocation.UpdateCity(xmlDataCity);
if (result == 1)
{
acbGeographicLocation.DefaultMode = true;
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Update].ToString());
Master.MessageCssClass = "successMessage";
if (ViewState[PageConstants.vsItemIndexes] != null)
htItemIndex = (Hashtable)ViewState[PageConstants.vsItemIndexes];
for (int i = 0; i < htItemIndex.Count; i++)
radgrdCity.Items[Convert.ToInt32(htItemIndex[i])].Edit = false;
bisEdit = false;
ViewState[PageConstants.vsItemIndexes] = null;
BindGridCity();
}
else
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Update].ToString());
Master.MessageCssClass = "errorMessage";
}
break;
}
break;
}
Reset();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{ throw ex; }
}
}
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; }
}
}
/// <summary>
/// Bind GeographicLocationLookupCity grid
/// </summary>
private void BindGridCity()
{
try
{
objGeographicLocation = new GeographicLocationDal();
DataSet dsGeographicCity = objGeographicLocation.GetCityName("");
radgrdCity.DataSource = dsGeographicCity;
radgrdCity.DataBind();
ViewState[vsGeographicCity] = dsGeographicCity;
if (radgrdCity != null)
{
for (int i = 0; i < radgrdCity.Items.Count; i++)
radgrdCity.Items[i].Edit = false;
}
}
catch (Exception ex)
{ }
}
/// <summary>
/// Bind GeographicLocationLookupState grid
/// </summary>
private void BindGridState()
{
try
{
objGeographicLocation = new GeographicLocationDal();
DataSet dsGeographicState = objGeographicLocation.GetStateName("");
radgrdState.DataSource = dsGeographicState;
radgrdState.DataBind();
ViewState[vsGeographicState] = dsGeographicState;
if (radgrdState != null)
{
for (int i = 0; i < radgrdState.Items.Count; i++)
radgrdState.Items[i].Edit = false;
}
}
catch (Exception ex)
{ }
}
