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);
}
