public SavingResult SaveNewRecord(tblTAApproval SaveModel)
{
SavingResult res = new SavingResult();
//-- Perform Validation
//res.ExecutionResult = eExecutionResult.ValidationError;
//res.ValidationError = "Validation error message";
//return res;
//--
using (dbVisionEntities db = new dbVisionEntities())
{
SaveNewRecord(SaveModel, db);
//--
try
{
db.SaveChanges();
res.PrimeKeyValue = SaveModel.TAApprovalID;
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
CommonFunctions.GetFinalError(res, ex);
}
}
return(res);
}
public SavingResult DeleteRecord(long DeleteID)
{
SavingResult res = new SavingResult();
using (dbVisionEntities db = new dbVisionEntities())
{
if (DeleteID != 0)
{
tblTAApproval RecordToDelete = db.tblTAApprovals.FirstOrDefault(r => r.TAApprovalID == 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.tblTAApprovals.Remove(RecordToDelete);
byte RecordState_Deleted = (byte)eRecordState.Deleted;
RecordToDelete.rstate = RecordState_Deleted;
db.tblTAApprovals.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);
}
public void SaveNewRecord(IEnumerable <TAApprovalImportViewModel> ImportViewModels)
{
using (dbVisionEntities db = new dbVisionEntities())
{
foreach (var viewModel in ImportViewModels)
{
tblTAApproval SaveModel = new tblTAApproval()
{
ApprovedDate = viewModel.ApprovedDate.Value,
TAApprovalNoPrefixID = viewModel.ApprovalNoPrefixID.Value,
TAApprovalNo = viewModel.ApprovalNo.Value,
EmployeeID = viewModel.EmployeeID.Value,
TAApprovalDate = viewModel.ApprovalDate.Value,
ApprovalTypeID = (byte)viewModel.ApprovalTypeID.Value,
ApprovedHours = viewModel.ApprovedHours.Value,
Remarks = viewModel.Remark,
};
SavingResult res = SaveNewRecord(SaveModel, db);
if (res.ExecutionResult != eExecutionResult.ErrorWhileExecuting && res.ExecutionResult != eExecutionResult.ValidationError)
{
try
{
db.SaveChanges();
res.PrimeKeyValue = SaveModel.TAApprovalID;
viewModel.TAApprovalID = SaveModel.TAApprovalID;
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
CommonFunctions.GetFinalError(res, ex);
}
}
viewModel.SavingResult = res;
}
}
}
public SavingResult SaveNewRecord(tblTAApproval SaveModel, dbVisionEntities db)
{
SavingResult res = new SavingResult();
//tblTAApproval SaveModel;
if (SaveModel.TAApprovalNo == 0)
{
res.ValidationError = "Please enter T & A Approval No.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
else if (IsDuplicateRecord(SaveModel.TAApprovalNoPrefixID, SaveModel.TAApprovalNo, SaveModel.TAApprovalID, db))
{
res.ValidationError = "Can not accept duplicate value. The T & A Approval No. is already exists.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
if (SaveModel.TAApprovalID == 0) // New Entry
{
SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.rcdt = DateTime.Now;
SaveModel.CompanyID = Model.CommonProperties.LoginInfo.LoggedInCompany.CompanyID;
SaveModel.FinPeriodID = Model.CommonProperties.LoginInfo.LoggedInFinPeriod.FinPeriodID;
db.tblTAApprovals.Add(SaveModel);
}
else
{
SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.redt = DateTime.Now;
db.tblTAApprovals.Attach(SaveModel);
db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
}
return(res);
}
public override void FillSelectedRecordInContent(object RecordToFill)
{
TAApprovalEditListModel EditingRecord = (TAApprovalEditListModel)RecordToFill;
tblTAApproval SaveModel = DALObject.FindSaveModelByPrimeKey(EditingRecord.TAApprovalID);
if (SaveModel == null)
{
return;
}
deTAApprovalDate.DateTime = SaveModel.TAApprovalDate;
lookupTAApprovalNoPrefix.EditValue = SaveModel.TAApprovalNoPrefixID;
txtTAApprovalNo.EditValue = SaveModel.TAApprovalNo;
lookupEmployee.EditValue = SaveModel.EmployeeID;
deApprovedDate.DateTime = SaveModel.ApprovedDate;
cmbApprovalType.SelectedIndex = SaveModel.ApprovalTypeID;
txtNofHours.EditValue = SaveModel.ApprovedHours;
txtRemarks.Text = SaveModel.Remarks;
txtDocument.Text = SaveModel.ApplicationDocumentFileName;
base.FillSelectedRecordInContent(RecordToFill);
}
public override void SaveRecord(SavingParemeter Paras)
{
DAL.tblTAApproval SaveModel = null;
if (Paras.SavingInterface == SavingParemeter.eSavingInterface.AddNew || EditRecordDataSource == null)
{
SaveModel = new tblTAApproval();
}
else
{
SaveModel = DALObject.FindSaveModelByPrimeKey(((TAApprovalEditListModel)EditRecordDataSource).TAApprovalID);
if (SaveModel == null)
{
Paras.SavingResult = new SavingResult();
Paras.SavingResult.ExecutionResult = eExecutionResult.ValidationError;
Paras.SavingResult.ValidationError = "Can not edit. Selected record not found, it may be deleted by another user.";
return;
}
}
SaveModel.TAApprovalDate = deTAApprovalDate.DateTime.Date;
SaveModel.TAApprovalNoPrefixID = (int)lookupTAApprovalNoPrefix.EditValue;
SaveModel.TAApprovalNo = Model.CommonFunctions.ParseInt(txtTAApprovalNo.Text);
SaveModel.EmployeeID = (int)lookupEmployee.EditValue;
SaveModel.ApprovedDate = deApprovedDate.DateTime;
SaveModel.ApprovalTypeID = (byte)cmbApprovalType.SelectedIndex;
SaveModel.ApprovedHours = txtNofHours.EditValueToDecimal();
SaveModel.Remarks = txtRemarks.Text;
// if new record or document has been changed then update it.
if (Paras.SavingInterface == SavingParemeter.eSavingInterface.AddNew || SaveModel.ApplicationDocumentFileName != txtDocument.Text)
{
SaveModel.ApplicationDocumentFileName = null;
if (!String.IsNullOrWhiteSpace(txtDocument.Text) && System.IO.File.Exists(txtDocument.Text))
{
string DocumentNewPath = Path.GetFullPath(Path.Combine(CommonProperties.LoginInfo.SoftwareSettings.DocumentLocation_TAApprovalDocument));
string DocumentNewFileName = Path.Combine(DocumentNewPath,
"TAAD" +
CommonProperties.LoginInfo.LoggedInCompany.CompanyID.ToString("000") +
CommonProperties.LoginInfo.LoggedInFinPeriod.FinPeriodID.ToString("000") +
lookupTAApprovalNoPrefix.Text +
SaveModel.TAApprovalNo.ToString("0000000000") +
Path.GetExtension(txtDocument.Text));
try
{
if (!Directory.Exists(DocumentNewPath))
{
Directory.CreateDirectory(DocumentNewPath);
}
// Allow to overwrite the document only if in edit mode
File.Copy(txtDocument.Text, DocumentNewFileName, (SaveModel.TAApprovalID != 0));
}
catch (System.IO.IOException ex)
{
SavingResult res = new SavingResult();
DAL.CommonFunctions.GetFinalError(res, ex);
Paras.SavingResult = res;
return;
}
SaveModel.ApplicationDocumentFileName = DocumentNewFileName;
}
}
Paras.SavingResult = DALObject.SaveNewRecord(SaveModel);
base.SaveRecord(Paras);
}
