public override void FillSelectedRecordInContent(object RecordToFill)
{
LocationEditListModel EditingRecord = (LocationEditListModel)RecordToFill;
if (EditingRecord == null)
{
return;
}
tblLocation SaveModel = DALObject.FindSaveModelByPrimeKey(EditingRecord.LocationID);
txtLocationName.Text = SaveModel.LocationName;
cmbLocationType.SelectedIndex = SaveModel.LocationTypeID;
txtGracePeriod.EditValue = SaveModel.GracePeriod;
LocationWeekendSettingViewModel WeekEndSetting = DALObject.GetLatestWeekendSetting(SaveModel.LocationID);
if (WeekEndSetting != null)
{
deWithEffectDate.EditValue = (WeekEndSetting.WEDateTo != null ? WeekEndSetting.WEDateTo.Value.AddDays(1).Date : DateTime.Now.Date);
cmbWeekendMonday.SelectedIndex = (int)WeekEndSetting.Monday;
cmbWeekendTuesday.SelectedIndex = (int)WeekEndSetting.Tuesday;
cmbWeekendWednesday.SelectedIndex = (int)WeekEndSetting.Wednesday;
cmbWeekendThursday.SelectedIndex = (int)WeekEndSetting.Thursday;
cmbWeekendFriday.SelectedIndex = (int)WeekEndSetting.Friday;
cmbWeekendSaturday.SelectedIndex = (int)WeekEndSetting.Saturday;
cmbWeekendSunday.SelectedIndex = (int)WeekEndSetting.Sunday;
}
else
{
deWithEffectDate.EditValue = null;
cmbWeekendMonday.SelectedIndex = 0;
cmbWeekendTuesday.SelectedIndex = 0;
cmbWeekendWednesday.SelectedIndex = 0;
cmbWeekendThursday.SelectedIndex = 0;
cmbWeekendFriday.SelectedIndex = 0;
cmbWeekendSaturday.SelectedIndex = 0;
cmbWeekendSunday.SelectedIndex = 0;
}
}
public SavingResult SaveNewRecord(tblLocation SaveModel, LocationWeekendSettingViewModel WeekendSetting)
{
SavingResult res = new SavingResult();
//-- Perform Validation
//res.ExecutionResult = eExecutionResult.ValidationError;
//res.ValidationError = "Validation error message";
//return res;
//--
using (dbVisionEntities db = new dbVisionEntities())
{
//tblLocation SaveModel;
if (SaveModel.LocationName == "")
{
res.ValidationError = "Can not accept blank value. Please enter Location Name.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
else if (IsDuplicateRecord(SaveModel.LocationName, SaveModel.LocationID, db))
{
res.ValidationError = "Can not accept duplicate value. The Location Name is already exists.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
if (SaveModel.LocationID == 0) // New Entry
{
SaveModel.CompanyID = CommonProperties.LoginInfo.LoggedInCompany.CompanyID;
SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.rcdt = DateTime.Now;
db.tblLocations.Add(SaveModel);
}
else
{
SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.redt = DateTime.Now;
db.tblLocations.Attach(SaveModel);
db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
if (WeekendSetting.WEDateFrom != null)
{
DateTime LastUptoDate = WeekendSetting.WEDateFrom.Value.Date.AddDays(-1);
foreach (var weekendRows in db.tblLocationWeekendSettings.Where(r => r.LocationID == SaveModel.LocationID &&
r.WEDateFrom < WeekendSetting.WEDateFrom && (r.WEDateTo == null || r.WEDateTo >= WeekendSetting.WEDateFrom)))
{
weekendRows.WEDateTo = LastUptoDate;
db.tblLocationWeekendSettings.Attach(weekendRows);
db.Entry(weekendRows).State = System.Data.Entity.EntityState.Modified;
}
db.tblLocationWeekendSettings.RemoveRange(db.tblLocationWeekendSettings.Where(r => r.LocationID == SaveModel.LocationID &&
r.WEDateFrom >= WeekendSetting.WEDateFrom));
}
else
{
db.tblLocationWeekendSettings.RemoveRange(db.tblLocationWeekendSettings.Where(r => r.LocationID == SaveModel.LocationID));
}
}
db.tblLocationWeekendSettings.Add(new tblLocationWeekendSetting()
{
tblLocation = SaveModel,
WEDateFrom = WeekendSetting.WEDateFrom,
Monday = (byte)WeekendSetting.Monday,
Tuesday = (byte)WeekendSetting.Tuesday,
Wednesday = (byte)WeekendSetting.Wednesday,
Thursday = (byte)WeekendSetting.Thursday,
Friday = (byte)WeekendSetting.Friday,
Saturday = (byte)WeekendSetting.Saturday,
Sunday = (byte)WeekendSetting.Sunday
});
//--
try
{
db.SaveChanges();
res.PrimeKeyValue = SaveModel.LocationID;
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
CommonFunctions.GetFinalError(res, ex);
}
}
return(res);
}
