public SavingResult DeleteRecord(long DeleteID) { SavingResult res = new SavingResult(); using (dbVisionEntities db = new dbVisionEntities()) { if (DeleteID != 0) { tblBiometricDevice RecordToDelete = db.tblBiometricDevices.FirstOrDefault(r => r.BMDID == 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 { byte RecordState_Deleted = (byte)eRecordState.Deleted; //db.tblBiometricDevice.Remove(RecordToDelete); RecordToDelete.rstate = RecordState_Deleted; db.tblBiometricDevices.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 SavingResult SaveNewRecord(tblBiometricDevice SaveModel) { SavingResult res = new SavingResult(); //-- Perform Validation //res.ExecutionResult = eExecutionResult.ValidationError; //res.ValidationError = "Validation error message"; //return res; //-- using (dbVisionEntities db = new dbVisionEntities()) { //tblBiometricDevice SaveModel; if (SaveModel.BMDTitle == "") { res.ValidationError = "Can not accept blank value. Please enter Biometric Device Title."; res.ExecutionResult = eExecutionResult.ValidationError; return(res); } //else if (IsDuplicateTitle(SaveModel.BMDTitle, SaveModel.BMDID, db)) //{ // res.ValidationError = "Can not accept duplicate value. The Biometric Device Title is already exists."; // res.ExecutionResult = eExecutionResult.ValidationError; // return res; //} if (String.IsNullOrWhiteSpace(SaveModel.IPAddress)) { res.ValidationError = "Can not accept blank value. Please enter IP Address."; res.ExecutionResult = eExecutionResult.ValidationError; return(res); } else if (IsDuplicateIPAddress(SaveModel.IPAddress, SaveModel.BMDID, db)) { res.ValidationError = "Can not accept duplicate value. The IP Address is already exists."; res.ExecutionResult = eExecutionResult.ValidationError; return(res); } if (SaveModel.BMDID == 0) // New Entry { SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID; SaveModel.CompanyID = Model.CommonProperties.LoginInfo.LoggedInCompany.CompanyID; SaveModel.rcdt = DateTime.Now; db.tblBiometricDevices.Add(SaveModel); } else { SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID; SaveModel.redt = DateTime.Now; db.tblBiometricDevices.Attach(SaveModel); db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified; } //-- try { db.SaveChanges(); res.PrimeKeyValue = SaveModel.BMDID; res.ExecutionResult = eExecutionResult.CommitedSucessfuly; } catch (Exception ex) { CommonFunctions.GetFinalError(res, ex); } } return(res); }