private void Update()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Update))
{
return;
}
if (!ValidateValues())
{
return;
}
bool bActionCompleted;
AccomodationSeasonDTO accomodationOldSeason = GetSeasonOldDates();
AccomodationSeasonDTO accomodationNewSeason = MapControlsToObject();
AccomodationMaster oAccomMaster = new AccomodationMaster();
bActionCompleted = oAccomMaster.UpdateAccomodationSeason(accomodationOldSeason, accomodationNewSeason);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been updated successfully");
ClearControls();
lblStatus.Text = "Updated Successfully";
}
else
{
lblStatus.Text = "Error Occured while updating: Please refer to the error log.";
}
RefreshGrid();
accomodationOldSeason = null;
accomodationNewSeason = null;
oAccomMaster = null;
}
private void Save()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add))
{
return;
}
if (!ValidateValues())
{
return;
}
AccomodationSeasonDTO accomodationSeasonDto = new AccomodationSeasonDTO();
AccomodationMaster oAccomMaster = new AccomodationMaster();
bool bActionCompleted;
accomodationSeasonDto = MapControlsToObject();
bActionCompleted = oAccomMaster.InsertAccomodationSeason(accomodationSeasonDto);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been insert successfully");
ClearControls();
lblStatus.Text = "Saved";
}
else
{
lblStatus.Text = "Error Occured while saving: Please refer to the error log.";
return;
}
RefreshGrid();
accomodationSeasonDto = null;
oAccomMaster = null;
}
public bool UpdateAccomodationSeason(AccomodationSeasonDTO accomodationOldSeason, AccomodationSeasonDTO accomodationNewSeason)
{
string sProcName;
DatabaseManager oDB;
try
{
sProcName = "up_Upd_AccomodationMasterSeasonDate";
oDB = new DatabaseManager();
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomId", DbType.Int32, accomodationOldSeason.AccomodationId);
if (accomodationOldSeason.SeasonStartDate == DateTime.MinValue)
{
accomodationOldSeason.SeasonStartDate = GF.ParseDate("1900-01-01");
}
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@OldSeasonStartDate", DbType.DateTime, accomodationOldSeason.SeasonStartDate);
if (accomodationOldSeason.SeasonEndDate == DateTime.MinValue)
{
accomodationOldSeason.SeasonEndDate = GF.ParseDate("1900-01-01");
}
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@OldSeasonEndDate", DbType.DateTime, accomodationOldSeason.SeasonEndDate);
if (accomodationNewSeason.SeasonStartDate == DateTime.MinValue)
{
accomodationNewSeason.SeasonStartDate = GF.ParseDate("1900-01-01");
}
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@NewSeasonStartDate", DbType.DateTime, accomodationNewSeason.SeasonStartDate);
if (accomodationNewSeason.SeasonEndDate == DateTime.MinValue)
{
accomodationNewSeason.SeasonEndDate = GF.ParseDate("1900-01-01");
}
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@NewSeasonEndDate", DbType.DateTime, accomodationNewSeason.SeasonEndDate);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsAccomodationMaster.up_Upd_AccomodationMasterSeasonDate", exp.Message.ToString());
oDB = null;
return(false);
}
finally
{
oDB = null;
}
return(true);
}
private AccomodationSeasonDTO MapControlsToObject()
{
DateTime dt;
AccomodationSeasonDTO accomodationSeasonDto = new AccomodationSeasonDTO();
int id = 0;
int.TryParse(hfId.Value, out id);
accomodationSeasonDto.AccomodationId = id;
DateTime.TryParse(txtSeasonStartDate.Text, out dt);
accomodationSeasonDto.SeasonStartDate = dt;
DateTime.TryParse(txtSeasonEndDate.Text, out dt);
accomodationSeasonDto.SeasonEndDate = dt;
return(accomodationSeasonDto);
}
private AccomodationSeasonDTO GetSeasonOldDates()
{
AccomodationSeasonDTO accomodationOldSeason = new AccomodationSeasonDTO();
int id = 0;
int.TryParse(hfId.Value, out id);
accomodationOldSeason.AccomodationId = id;
DateTime dt;
DateTime.TryParse(hfOldSeasonStartDate.Value, out dt);
accomodationOldSeason.SeasonStartDate = dt;
DateTime.TryParse(hfOldSeasonEndDate.Value, out dt);
accomodationOldSeason.SeasonEndDate = dt;
return(accomodationOldSeason);
}
private void Delete()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Delete))
{
return;
}
bool bActionCompleted;
string sMessage = "";
AccomodationSeasonDTO accomodationSeason = MapControlsToObject();
AccomodationMaster oAccomMaster = new AccomodationMaster();
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit again.";
return;
}
GF.HasRecords(Convert.ToString(Id), "accomodation", out sMessage);
if (sMessage != "")
{
base.DisplayAlert(sMessage);
btnDelete.Enabled = true;
}
else
{
bActionCompleted = oAccomMaster.DeleteAccomodationSeason(accomodationSeason);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been deleted successfully.");
ClearControls();
}
else
{
base.DisplayAlert("Error Occured while deletion: Please refer to the error log.");
}
}
oAccomMaster = null;
accomodationSeason = null;
}
public List <AccomodationSeasonDTO> GetAccomodationSeasonDates(int AccomodationId)
{
DataSet ds;
List <AccomodationSeasonDTO> accomodationSeasonList = new List <AccomodationSeasonDTO>();
AccomodationSeasonDTO accomodationSeason = null;
ds = null;
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Get_AccomodationMasterSeasonDates";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomId", DbType.Int32, AccomodationId);
ds = oDB.ExecuteDataSet(oDB.DbCmd);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
accomodationSeason = new AccomodationSeasonDTO();
accomodationSeason.AccomodationId = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
accomodationSeason.SeasonStartDate = ds.Tables[0].Rows[i][1] != DBNull.Value ? Convert.ToDateTime(ds.Tables[0].Rows[i][1].ToString()) : DateTime.MinValue;
accomodationSeason.SeasonEndDate = ds.Tables[0].Rows[i][2] != DBNull.Value ? Convert.ToDateTime(ds.Tables[0].Rows[i][2].ToString()) : DateTime.MinValue;
accomodationSeasonList.Add(accomodationSeason);
}
}
}
catch (Exception exp)
{
GF.LogError("clsAccomodationMaster.Update", exp.Message.ToString());
oDB = null;
}
finally
{
oDB = null;
}
return(accomodationSeasonList);
}
