public SavingResult SaveNewRecord(tblLeaveType SaveModel)
{
SavingResult res = new SavingResult();
//-- Perform Validation
//res.ExecutionResult = eExecutionResult.ValidationError;
//res.ValidationError = "Validation error message";
//return res;
//--
using (dbVisionEntities db = new dbVisionEntities())
{
//tblLeaveType SaveModel;
if (SaveModel.LeaveTypeName == "")
{
res.ValidationError = "Can not accept blank value. Please enter Leave Type Name.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
else if (IsDuplicateRecord(SaveModel.LeaveTypeName, SaveModel.LeaveTypeID, db))
{
res.ValidationError = "Can not accept duplicate value. The Leave Type Name is already exists.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
if (SaveModel.LeaveTypeID == 0) // New Entry
{
SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.rcdt = DateTime.Now;
SaveModel.CompanyID = Model.CommonProperties.LoginInfo.LoggedInCompany.CompanyID;
db.tblLeaveTypes.Add(SaveModel);
}
else
{
SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.redt = DateTime.Now;
db.tblLeaveTypes.Attach(SaveModel);
db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
}
//--
try
{
db.SaveChanges();
res.PrimeKeyValue = SaveModel.LeaveTypeID;
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
CommonFunctions.GetFinalError(res, ex);
}
}
return(res);
}
private void lookupLeaveType_EditValueChanged(object sender, EventArgs e)
{
UpdateBalance();
if (lookupLeaveType.EditValue != null)
{
SelectedLeaveType = LeaveTypeDALObj.FindSaveModelByPrimeKey((int)lookupLeaveType.EditValue);
}
else
{
SelectedLeaveType = null;
}
LoadDayDetail();
}
public override void FillSelectedRecordInContent(object RecordToFill)
{
tblLeaveType EditingRecord = DALObject.FindSaveModelByPrimeKey(((LeaveTypeEditListModel)RecordToFill).LeaveTypeID);
if (EditingRecord == null)
{
return;
}
txtLeaveTypeName.Text = EditingRecord.LeaveTypeName;
txtAnnualEntitledDays.EditValue = EditingRecord.AnnualEntitledDays;
cmbApplicableTo.SelectedIndex = EditingRecord.ApplicableTo;
txtNotes.Text = EditingRecord.Notes;
cmbEncashable.SelectedIndex = (EditingRecord.IsEncashable ? 0 : 1);
cmbCarryForwardable.SelectedIndex = (EditingRecord.CanCarryForward ? 0 : 1);
cmbIncludeWeekend.SelectedIndex = (EditingRecord.IncludeWeekend ? 0 : 1);
cmbIncludePublicHoliday.SelectedIndex = (EditingRecord.IncludePublicHoliday ? 0 : 1);
cmbLeaveDistribution.SelectedIndex = EditingRecord.Distribute;
}
public SavingResult DeleteRecord(long DeleteID)
{
SavingResult res = new SavingResult();
using (dbVisionEntities db = new dbVisionEntities())
{
if (DeleteID != 0)
{
tblLeaveType RecordToDelete = db.tblLeaveTypes.FirstOrDefault(r => r.LeaveTypeID == DeleteID);
if (RecordToDelete == null)
{
res.ValidationError = "Selected record not found. May be it has been deleted by another user over network.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
else
{
//db.tblLeaveTypes.Remove(RecordToDelete);
byte RecordState_Deleted = (byte)eRecordState.Deleted;
RecordToDelete.rstate = RecordState_Deleted;
db.tblLeaveTypes.Attach(RecordToDelete);
db.Entry(RecordToDelete).State = System.Data.Entity.EntityState.Modified;
}
try
{
db.SaveChanges();
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
CommonFunctions.GetFinalError(res, ex);
}
}
}
return(res);
}
