public BeforeDeleteValidationResult ValidateBeforeDelete(int DeleteID) { BeforeDeleteValidationResult Result = new BeforeDeleteValidationResult(); Result.IsValidForDelete = true; return(Result); }
public BeforeDeleteValidationResult ValidateBeforeDelete(long DeleteID) { BeforeDeleteValidationResult Result = new BeforeDeleteValidationResult(); using (dbVisionEntities db = new dbVisionEntities()) { if (DeleteID == Model.CommonProperties.LoginInfo.LoggedInFinPeriod.FinPeriodID) { Result.ValidationMessage = "Can not delete current logged in financial period. Please login other financial period to delete this."; } else { tblFinPeriod FirstFinPer = db.tblFinPeriods.Where(r => r.CompanyID == CommonProperties.LoginInfo.LoggedInCompany.CompanyID).OrderBy(r => r.FinPeriodFrom).FirstOrDefault(); tblFinPeriod LastFinPer = db.tblFinPeriods.Where(r => r.CompanyID == CommonProperties.LoginInfo.LoggedInCompany.CompanyID).OrderByDescending(r => r.FinPeriodFrom).FirstOrDefault(); if (DeleteID != FirstFinPer.FinPeriodID && DeleteID != LastFinPer.FinPeriodID) { Result.ValidationMessage = "Can not delete. Oldest or newest finacial period can be deleted."; } else { tblFinPeriod RecordToDelete = db.tblFinPeriods.FirstOrDefault(r => r.FinPeriodID == DeleteID); if (RecordToDelete != null) { long CompanyID = RecordToDelete.CompanyID; long FinPeriodID = RecordToDelete.FinPeriodID; ///// Receipt //List<tblReceipt> ReceiptsToDelete = db.tblReceipts.Where(r => r.CompanyID == CompanyID && r.FinPeriodID == FinPeriodID).ToList(); //DAL.CashBank.ReceiptDAL RecietpDALObject = new CashBank.ReceiptDAL(); //foreach (tblReceipt Rec in ReceiptsToDelete) //{ // BeforeDeleteValidationResult ValRes = RecietpDALObject.ValidateBeforeDelete(Rec.ReceiptID); // if (!ValRes.IsValidForDelete) // { // Result.IsValidForDelete = false; // Result.ValidationMessage += "\r\nReceipt : " + ValRes.ValidationMessage; // } //} //// Sale //DAL.Sales.SaleInvoiceDAL SaleDALObject = new Sales.SaleInvoiceDAL(); //List<tblSaleInvoice> SalesToDelete = db.tblSaleInvoices.Where(r => r.CompanyID == CompanyID && r.FinPeriodID == FinPeriodID).ToList(); //foreach (tblSaleInvoice Rec in SalesToDelete) //{ // BeforeDeleteValidationResult ValRes = SaleDALObject.ValidateBeforeDelete(Rec.SaleInvoiceID); // if (!ValRes.IsValidForDelete) // { // Result.IsValidForDelete = false; // Result.ValidationMessage += "\r\nSale : " + ValRes.ValidationMessage; // } //} } } } } Result.IsValidForDelete = String.IsNullOrWhiteSpace(Result.ValidationMessage); return(Result); }
public BeforeDeleteValidationResult ValidateBeforeDelete(long DeleteID) { BeforeDeleteValidationResult Result = new BeforeDeleteValidationResult(); using (dbVisionEntities db = new dbVisionEntities()) { } Result.IsValidForDelete = String.IsNullOrWhiteSpace(Result.ValidationMessage); return(Result); }
public BeforeDeleteValidationResult ValidateBeforeDelete(int ID) { BeforeDeleteValidationResult res = new BeforeDeleteValidationResult() { IsValidForDelete = true }; return(res); //using (dbUltraCoralEntities db = new dbUltraCoralEntities()) //{ // return ValidateBeforeDelete(ID, db); //} }
public BeforeDeleteValidationResult ValidateBeforeDelete(int ID, dbUltraCoralEntities db) { BeforeDeleteValidationResult res = new BeforeDeleteValidationResult() { IsValidForDelete = true }; //if (db.tblSaleInvoices.FirstOrDefault(r => r.SaleOrderID == ID) != null) //{ // res.IsValidForDelete = false; // res.ValidationMessage = "Already selected in invoice."; //} return(res); }
public BeforeDeleteValidationResult ValidateBeforeDelete(int ID, dbUltraCoralEntities db) { BeforeDeleteValidationResult res = new BeforeDeleteValidationResult() { IsValidForDelete = true }; if (db.tblProducts.FirstOrDefault(r => r.ScientificNameID == ID) != null) { res.IsValidForDelete = false; res.ValidationMessage = "Already selected in products."; } return(res); }
public BeforeDeleteValidationResult ValidateBeforeDelete(long DeleteID) { BeforeDeleteValidationResult Result = new BeforeDeleteValidationResult(); using (dbVisionEntities db = new dbVisionEntities()) { //bool IsValidForDelete = db.tblCompanies.FirstOrDefault(r => r.LocationID == DeleteID) != null; //if (IsValidForDelete) //{ // Result.ValidationMessage = "Location is selected in company"; //} } Result.IsValidForDelete = String.IsNullOrWhiteSpace(Result.ValidationMessage); return(Result); }
public BeforeDeleteValidationResult ValidateBeforeDelete(long DeleteID) { BeforeDeleteValidationResult Result = new BeforeDeleteValidationResult(); using (dbVisionEntities db = new dbVisionEntities()) { bool InState = db.tblStates.FirstOrDefault(r => r.CountryID == DeleteID) != null; if (InState) { Result.ValidationMessage = "Country exists in some states"; } } Result.IsValidForDelete = String.IsNullOrWhiteSpace(Result.ValidationMessage); return(Result); }
public BeforeDeleteValidationResult ValidateBeforeDelete(int DeleteID) { BeforeDeleteValidationResult Result = new BeforeDeleteValidationResult(); Result.IsValidForDelete = true; //using (dbVisionEntities db = new dbVisionEntities()) //{ // bool InState = db.tblCompanies.FirstOrDefault(r => r.EmployeeDesignationID == DeleteID) != null; // if (InState) // { // Result.ValidationMessage = "Country is selected in company"; // } //} //Result.IsValidForDelete = String.IsNullOrWhiteSpace(Result.ValidationMessage); return(Result); }
public BeforeDeleteValidationResult ValidateBeforeDelete(long DeleteID) { BeforeDeleteValidationResult Result = new BeforeDeleteValidationResult(); using (dbVisionEntities db = new dbVisionEntities()) { bool InState = db.tblCompanies.FirstOrDefault(r => r.CityID == DeleteID) != null; if (InState) { Result.ValidationMessage = "City is selected in company"; } } Result.IsValidForDelete = String.IsNullOrWhiteSpace(Result.ValidationMessage); return(Result); }
public SavingResult DeleteRecord(int ID) { SavingResult res = new SavingResult(); using (dbUltraCoralEntities db = new dbUltraCoralEntities()) { BeforeDeleteValidationResult BeforeDeleteValres = ValidateBeforeDelete(ID, db); if (!BeforeDeleteValres.IsValidForDelete) { res.ExecutionResult = eExecutionResult.ValidationError; res.ValidationError = "Following errors occured while deleting. " + BeforeDeleteValres.ValidationMessage; return(res); } var RecordToDelete = db.tblSaleOrders.Find(ID); if (RecordToDelete == null) { res.ExecutionResult = eExecutionResult.ValidationError; res.ValidationError = "Selected record is already deleted or changed over network. Record not found."; return(res); } db.tblSaleOrderProductDetails.RemoveRange(db.tblSaleOrderProductDetails.Where(r => r.SaleOrderID == ID)); db.tblSaleOrders.Remove(RecordToDelete); //-- try { db.SaveChanges(); res.ExecutionResult = eExecutionResult.CommitedSucessfuly; } catch (Exception ex) { ex = Common.Functions.FindFinalError(ex); res.ExecutionResult = eExecutionResult.ErrorWhileExecuting; res.Exception = ex; } } return(res); }
public BeforeDeleteValidationResult ValidateBeforeDelete(long DeleteID) { BeforeDeleteValidationResult Result = new BeforeDeleteValidationResult(); using (dbVisionEntities db = new dbVisionEntities()) { var DeleteRecord = db.tblUsers.Find(DeleteID); if (DeleteRecord != null) { if (DeleteRecord.SuperAdmin) { Result.IsValidForDelete = false; Result.ValidationMessage = "Can not delete super admin record."; return(Result); } } } Result.IsValidForDelete = true; return(Result); }
public BeforeDeleteValidationResult ValidateBeforeDelete(long DeleteID) { BeforeDeleteValidationResult Result = new BeforeDeleteValidationResult(); if (DeleteID == CommonProperties.LoginInfo.LoggedInCompany.CompanyID) { Result.ValidationMessage = "Can not delete current logged in company. Please log in different company and try to delete."; } //using (dbVisionEntities db = new dbVisionEntities()) //{ //bool InState = db.tblCompanies.FirstOrDefault(r => r.CompanyID == DeleteID) != null; //if (InState) //{ // Result.ValidationMessage = "Country is selected in company"; //} //} Result.IsValidForDelete = String.IsNullOrWhiteSpace(Result.ValidationMessage); return(Result); }
public BeforeDeleteValidationResult ValidateBeforeDelete(long DeleteID) { BeforeDeleteValidationResult Result = new BeforeDeleteValidationResult(); using (dbVisionEntities db = new dbVisionEntities()) { var DeleteRecord = db.tblUserGroups.Find(DeleteID); if (DeleteRecord != null && (DeleteRecord.SuperAdminGroup)) { Result.ValidationMessage = "Can not delete super admin group"; Result.IsValidForDelete = false; return(Result); } else if (db.tblUserGroups.Any(r => r.UserGroupID == DeleteID)) { Result.ValidationMessage = "Selected group already selected in some users."; Result.IsValidForDelete = false; return(Result); } } Result.IsValidForDelete = true; return(Result); }
public SavingResult DeleteRecord(int ID) { SavingResult res = new SavingResult(); using (dbUltraCoralEntities db = new dbUltraCoralEntities()) { BeforeDeleteValidationResult BeforeDeleteValres = ValidateBeforeDelete(ID, db); if (!BeforeDeleteValres.IsValidForDelete) { res.ExecutionResult = eExecutionResult.ValidationError; res.ValidationError = "Following errors occured while deleting. " + BeforeDeleteValres.ValidationMessage; return(res); } var RecordToDelete = db.tblSaleInvoices.Find(ID); if (RecordToDelete == null) { res.ExecutionResult = eExecutionResult.ValidationError; res.ValidationError = "Selected record is already deleted or changed over network. Record not found."; return(res); } foreach (tblSaleInvoiceProductDetail SIPD in RecordToDelete.tblSaleInvoiceProductDetails) { tblProduct Product = db.tblProducts.Find(SIPD.ProductID); if (Product != null) { Product.CurrentStock += SIPD.Quan; db.tblProducts.Attach(Product); db.Entry(Product).State = System.Data.Entity.EntityState.Modified; } } db.tblSaleInvoiceProductDetails.RemoveRange(db.tblSaleInvoiceProductDetails.Where(r => r.SaleInvoiceID == ID)); //if (RecordToDelete.SaleOrderID != null && RecordToDelete.SaleOrderID != 0) //{ // tblSaleOrder SaleOrder = db.tblSaleOrders.Find(RecordToDelete.SaleOrderID); // SaleOrder.tblSaleInvoice = null; // SaleOrder.SaleInvoiceID = null; // db.tblSaleOrders.Attach(SaleOrder); // db.Entry(SaleOrder).State = System.Data.Entity.EntityState.Modified; //} db.tblSaleInvoices.Remove(RecordToDelete); //-- try { db.SaveChanges(); res.ExecutionResult = eExecutionResult.CommitedSucessfuly; } catch (Exception ex) { ex = Common.Functions.FindFinalError(ex); res.ExecutionResult = eExecutionResult.ErrorWhileExecuting; res.Exception = ex; } } return(res); }