/// <summary>
/// Takes the fa.
/// </summary>
/// <param name="fAAdjustmentEntity">The f a adjustment entity.</param>
/// <returns></returns>
private static object[] TakeFA(FAAdjustmentEntity fAAdjustmentEntity)
{
return(new object[]
{
"@RefDetailID", fAAdjustmentEntity.RefDetailId,
"@RefID", fAAdjustmentEntity.RefId,
"@FixedAssetID", fAAdjustmentEntity.FixedAssetId,
"@NewOrgPrice", fAAdjustmentEntity.NewOrgPrice,
"@OldOrgPrice", fAAdjustmentEntity.OldOrgPrice,
"@DiffOrgPrice", fAAdjustmentEntity.DiffOrgPrice,
"@NewDevaluationAmount", fAAdjustmentEntity.NewDevaluationAmount,
"@OldDevaluationAmount", fAAdjustmentEntity.OldDevaluationAmount,
"@DiffDevaluationAmount", fAAdjustmentEntity.DiffDevaluationAmount,
"@NewAccumDepreciationAmount", fAAdjustmentEntity.NewAccumDepreciationAmount,
"@OldAccumDepreciationAmount", fAAdjustmentEntity.OldAccumDepreciationAmount,
"@DiffAccumDepreciationAmount", fAAdjustmentEntity.DiffAccumDepreciationAmount,
"@NewAccumDevaluationAmount", fAAdjustmentEntity.NewAccumDevaluationAmount,
"@OldAccumDevaluationAmount", fAAdjustmentEntity.OldAccumDevaluationAmount,
"@DiffAccumDevaluationAmount", fAAdjustmentEntity.DiffAccumDevaluationAmount,
"@NewRemainingAmount", fAAdjustmentEntity.NewRemainingAmount,
"@OldRemainingAmount", fAAdjustmentEntity.OldRemainingAmount,
"@DiffRemainingAmount", fAAdjustmentEntity.DiffRemainingAmount,
"@NewQuantity", fAAdjustmentEntity.NewQuantity,
"@OldQuantity", fAAdjustmentEntity.OldQuantity,
"@DiffQuantity", fAAdjustmentEntity.DiffQuantity,
"@NewAnnualDepreciationAmount", fAAdjustmentEntity.NewAnnualDepreciationAmount,
"@OldAnnualDepreciationAmount", fAAdjustmentEntity.OldAnnualDepreciationAmount,
"@DiffAnnualDepreciationAmount", fAAdjustmentEntity.DiffAnnualDepreciationAmount
});
}
/// <summary>
/// Deletes the fa adjustment.
/// </summary>
/// <param name="fAAdjustment">The f a adjustment.</param>
/// <returns></returns>
public string DeleteFAAdjustment(FAAdjustmentEntity fAAdjustment)
{
const string sql = @"uspDelete_FAAdjustment";
object[] parms = { "@RefID", fAAdjustment.RefId };
return(Db.Delete(sql, true, parms));
}
//public FAIncrementDecrementEntity GetFAIncrementDecrementByRefNo(string refNo)
//{
// const string procedures = @"uspGet_FAIncrementDecrement_ByRefNo";
// object[] parms = {"@RefNo", refNo};
// return Db.Read(procedures, true, Make, parms);
//}
/// <summary>
/// Takes the specified s u increment decrement entity.
/// </summary>
/// <param name="fAAdjustmentEntity">The f a adjustment entity.</param>
/// <returns></returns>
private static object[] Take(FAAdjustmentEntity fAAdjustmentEntity)
{
return(new object[]
{
"@RefID", fAAdjustmentEntity.RefId,
"@RefType", fAAdjustmentEntity.RefType,
"@RefDate", fAAdjustmentEntity.RefDate,
"@PostedDate", fAAdjustmentEntity.PostedDate,
"@RefNo", fAAdjustmentEntity.RefNo,
"@ParalellRefNo", fAAdjustmentEntity.ParalellRefNo,
"@JournalMemo", fAAdjustmentEntity.JournalMemo,
"@TotalAmount", fAAdjustmentEntity.TotalAmount,
"@FixedAssetID", fAAdjustmentEntity.FixedAssetId,
"@FixedAssetName", fAAdjustmentEntity.FixedAssetName,
"@Posted", fAAdjustmentEntity.Posted,
"@PostVersion", fAAdjustmentEntity.PostVersion,
"@EditVersion", fAAdjustmentEntity.EditVersion,
"@AppliedYear", fAAdjustmentEntity.AppliedYear,
"@EndYear", fAAdjustmentEntity.EndYear,
"@EndDevaluationDate", fAAdjustmentEntity.EndDevaluationDate,
"@FARefOrder", fAAdjustmentEntity.FARefOrder
});
}
/// <summary>
/// Inserts the fa adjustment detail fa.
/// </summary>
/// <param name="fAAdjustmentEntity">The f a adjustment entity.</param>
/// <returns></returns>
public string InsertFAAdjustmentDetailFA(FAAdjustmentEntity fAAdjustmentEntity)
{
const string sql = @"uspInsert_FAAdjustmentDetailFA";
return(Db.Insert(sql, true, TakeFA(fAAdjustmentEntity)));
}
/// <summary>
/// Inserts the fa adjustment.
/// </summary>
/// <param name="fAAdjustmentEntity">The f a adjustment entity.</param>
/// <returns></returns>
public string UpdateFAAdjustment(FAAdjustmentEntity fAAdjustmentEntity)
{
const string sql = @"uspUpdate_FAAdjustment";
return(Db.Insert(sql, true, Take(fAAdjustmentEntity)));
}
public List <FAAdjustmentEntity> GetFAAdjustments(string connectionString)
{
List <FAAdjustmentEntity> buentity = new List <FAAdjustmentEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.FAAdjustmentDetails.ToList();
var projects = context.Projects.ToList();
//var currencys = context.CCies.ToList();
var budgetsource = context.BudgetSources.ToList();
var listitems = context.ListItems.ToList();
//var funds = context.Funds.ToList();
var fundstructures = context.FundStructures.ToList();
var budgetproviders = context.BudgetProvidences.ToList();
var accountingobject = context.AccountingObjects.ToList();
var projectexpenses = context.ProjectExpenses.ToList();
var activity = context.Activities.ToList();
//var tasks = context.Tasks.ToList();
var topics = context.Topics.ToList();
banks = context.BankInfoes.ToList();
//var department = context.Departments.ToList();
var fixedasset = context.FixedAssets.ToList();
//var inventoryitems = context.InventoryItems.ToList();
//var stocks = context.Stocks.ToList();
var resultcontext = context.FAAdjustments.ToList();
var detailfixedasset = context.FAAdjustmentDetailFAs.ToList();
foreach (var result in resultcontext)
{
var newresult = new FAAdjustmentEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.ParalellRefNo = result.ParalellRefNo;
newresult.FixedAssetId = result.FixedAsset == null ? null : result.FixedAsset.FixedAssetID.ToString();
newresult.FixedAssetName = result.FixedAssetName;
newresult.JournalMemo = result.JournalMemo;
newresult.Posted = result.Posted;
newresult.TotalAmount = result.TotalAmount;
newresult.PostVersion = result.PostVersion ?? 0;
newresult.EditVersion = result.EditVersion;
newresult.AppliedYear = result.AppliedYear ?? 0;
newresult.EndYear = result.EndYear ?? 0;
newresult.FARefOrder = result.FARefOrder;
newresult.EndDevaluationDate = result.EndDevaluationDate ?? result.RefDate;
newresult.FAAdjustmentDetails = result.FAAdjustmentDetails.Count <= 0 ? null : FAAdjustmentDetails(result.FAAdjustmentDetails.ToList(), result.RefID.ToString());
newresult.OldOrgPrice = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].OldOrgPrice;
newresult.OldDevaluationAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].OldDevaluationAmount;
newresult.OldAccumDevaluationAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].OldAccumDevaluationAmount;
newresult.OldAccumDepreciationAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].OldAccumDepreciationAmount;
newresult.OldRemainingAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].OldRemainingAmount;
//newresult.OldAnnualDepreciationRate = result.OldAnnualDepreciationRate;
newresult.OldAnnualDepreciationAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].OldAnnualDepreciationAmount;
//newresult.OldPeriodDevaluationAmount = result.OldPeriodDevaluationAmount;
newresult.OldQuantity = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].OldQuantity;
//newresult.OldProductionRate = result.OldProductionRate;
//newresult.OldDevaluationRate = result.OldDevaluationRate;
//newresult.OldRemainingDevaluationLifeTime = result.OldRemainingDevaluationLifeTime;
newresult.NewOrgPrice = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].NewOrgPrice;
newresult.NewDevaluationAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].NewDevaluationAmount;
newresult.NewAccumDevaluationAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].NewAccumDevaluationAmount;
newresult.NewAccumDepreciationAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].NewAccumDepreciationAmount;
newresult.NewRemainingAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].NewRemainingAmount;
//newresult.NewAnnualDepreciationRate = result.NewAnnualDepreciationRate;
newresult.NewAnnualDepreciationAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].NewAnnualDepreciationAmount;
//newresult.NewPeriodDevaluationAmount = result.NewPeriodDevaluationAmount;
newresult.NewQuantity = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].NewQuantity;
//newresult.NewProductionRate = result.NewProductionRate;
//newresult.NewDevaluationRate = result.NewDevaluationRate;
//newresult.NewRemainingDevaluationLifeTime = result.NewRemainingDevaluationLifeTime;
//newresult.NewRemainingLifeTime = result.NewRemainingLifeTime;
newresult.DiffOrgPrice = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].DiffOrgPrice;
newresult.DiffDevaluationAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].DiffDevaluationAmount;
newresult.DiffAccumDevaluationAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].DiffAccumDevaluationAmount;
newresult.DiffAccumDepreciationAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].DiffAccumDepreciationAmount;
newresult.DiffRemainingAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].DiffRemainingAmount;
//newresult.DiffAnnualDepreciationRate = result.DiffAnnualDepreciationRate;
newresult.DiffAnnualDepreciationAmount = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].DiffAnnualDepreciationAmount;
//newresult.DiffPeriodDevaluationAmount = result.DiffPeriodDevaluationAmount;
newresult.DiffQuantity = result.FAAdjustmentDetails.Count <= 0 ? 0 : result.FAAdjustmentDetailFAs.ToList()[0].DiffQuantity;
//newresult.SortOrder = result.SortOrder;
//newresult.EndYear = result.EndYear;
//newresult.F = result.FAAdjustmentDetails.Count <= 0 ? null : FAAdjustmentDetails(result.FAAdjustmentDetails.ToList(), result.RefID.ToString());
buentity.Add(newresult);
}
}
return(buentity);
}
