public ActionResult Update()
{
string UserID = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(UserID);
var HeadrObj = new Header();
int CurrYear = UserInfo.CurrYear;
HeadrObj.VoucherDate = DateTime.Parse("31/12/" + (CurrYear - 1).ToString());
var TransObj = new List <Transaction>();
var CompanyTransactionKindObj = _unitOfWork.NativeSql.GetCompanyTransactionKindAll(UserInfo.fCompanyId);
CompanyTransactionKindObj = CompanyTransactionKindObj.Where(m => m.TransactionKindID == (int)EnumTransKind.OpenBalance);
var CompanyTransactionKindID = _unitOfWork.CompanyTransactionKind.GetCompanyTransactionKindByTransKindNo(UserInfo.fCompanyId, (int)EnumTransKind.OpenBalance);
HeadrObj.VoucherNumber = "1";// _unitOfWork.Header.GetMaxVHByKind(UserInfo.fCompanyId, CompanyTransactionKindID,(int)EnumTransKind.OpenBalance).ToString();
HeadrObj.VHI = int.Parse(HeadrObj.VoucherNumber);
DateTime dt = DateTime.Parse("31/12/" + (UserInfo.CurrYear - 1).ToString());
var Data = _unitOfWork.NativeSql.GetOpenBalance(UserInfo.fCompanyId, dt, dt);
// var Data = _unitOfWork.NativeSql.GetTransActionAccountForBalance(UserInfo.fCompanyId);
var OpeningBalanceCredit = Data.Sum(m => m.CreditBalance);
var OpeningBalanceDebit = Data.Sum(m => m.DebitBalance);
HeadrObj.TotalCredit = OpeningBalanceCredit;
HeadrObj.TotalDebit = OpeningBalanceDebit;
var Company = _unitOfWork.Company.GetMyCompany(UserInfo.fCompanyId);
var Obj = new OpeningBalanceVM
{
Header = HeadrObj,
Transaction = TransObj,
CompanyTransactionKind = CompanyTransactionKindObj,
CompanyTransactionKindID = CompanyTransactionKindID,
CurrencyNewValue = 0,
Credit = OpeningBalanceCredit,
Debit = OpeningBalanceDebit,
NetTOT = OpeningBalanceDebit - OpeningBalanceCredit,
TotalCredit = OpeningBalanceCredit.ToString(),
TotalDebit = OpeningBalanceDebit.ToString(),
sNetTotal = (OpeningBalanceDebit - OpeningBalanceCredit).ToString(),
TheDecimalPointForTheForeignCurrency = Company.TheDecimalPointForTheForeignCurrency,
TheDecimalPointForTheLocalCurrency = Company.TheDecimalPointForTheLocalCurrency
};
return(View(Obj));
}
public ActionResult GridViewTransActionPartial(string id, string id2)
{
string UserID = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(UserID);
// var Data = _unitOfWork.NativeSql.GetTransActionAccountForBalance(UserInfo.fCompanyId);
DateTime dt = new DateTime();
dt = DateTime.Parse("31/12/" + (UserInfo.CurrYear - 1).ToString());
var Y = _unitOfWork.NativeSql.GetAllYear();
int Min = Y.Min(m => m.Year);
if (Min != UserInfo.CurrYear)
{
var Data = _unitOfWork.NativeSql.GetOpenBalance(UserInfo.fCompanyId, dt, dt);
Data = Data.OrderBy(m => m.AccountNumber).ToList();
var TransObj = new List <OpeningBalanceVM>();
if (Data.Count() > 0)
{
foreach (var Acc in Data)
{
var Obj = new OpeningBalanceVM();
Obj.AccountNumber = Acc.AccountNumber;
Obj.AccountName = Acc.AccountName;
Obj.Credit = Acc.CreditBalance;
Obj.Debit = Acc.DebitBalance;
if (Acc.DebitBalance == 0)
{
Obj.sDebit = "";
}
else
{
Obj.sDebit = Acc.DebitBalance.ToString();
}
TransObj.Add(Obj);
}
return(PartialView("GridViewTransActionPartial", TransObj));
}
else
{
return(PartialView("GridViewTransActionPartial", TransObj));
}
}
else
{
var Data = _unitOfWork.NativeSql.GetTransActionAccountForBalance(UserInfo.fCompanyId);
Data = Data.OrderBy(m => m.AccountNumber).ToList();
var TransObj = new List <OpeningBalanceVM>();
if (Data.Count() > 0)
{
foreach (var Acc in Data)
{
var Obj = new OpeningBalanceVM();
Obj.AccountNumber = Acc.AccountNumber;
Obj.AccountName = Acc.ArabicName;
Obj.Credit = Acc.OpeningBalanceCredit;
Obj.Debit = Acc.OpeningBalanceDebit;
if (Acc.OpeningBalanceDebit == 0)
{
Obj.sDebit = "";
}
else
{
Obj.sDebit = Acc.OpeningBalanceDebit.ToString();
}
TransObj.Add(Obj);
}
return(PartialView("GridViewTransActionPartial", TransObj));
}
else
{
return(PartialView("GridViewTransActionPartial", TransObj));
}
}
}
