public static A2ZPENSIONDEFAULTERDTO GetPensionDepInformation(DateTime TrnDate, Int16 CuType, int CuNo, int MemNo, int AccType, Int64 AccNo)
{
var prm1 = new object[1];
prm1[0] = AccNo;
DataTable dt2 = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_CSGenerateTodaysPensionDeposit", prm1, "A2ZCSMCUS");
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE AccType = '" + AccType + "' and AccNo = '" +
AccNo + "' and CuType='" + CuType + "' and CuNo='" + CuNo + "' and MemNo='" + MemNo + "'", "A2ZCSMCUS");
var p = new A2ZPENSIONDEFAULTERDTO();
if (dt.Rows.Count > 0)
{
p.TotalDepositAmt = Converter.GetDecimal(dt.Rows[0]["AccTotalDep"]);
p.Opendate = Converter.GetDateTime(dt.Rows[0]["AccOpenDate"]);
p.MthDeposit = Converter.GetDecimal(dt.Rows[0]["AccMonthlyDeposit"]);
p.Period = Converter.GetInteger(dt.Rows[0]["AccPeriod"]);
p.CalPaidDeposit = Converter.GetDecimal(dt.Rows[0]["CalPaidDeposit"]);
p.CalPaidPenal = Converter.GetDecimal(dt.Rows[0]["CalPaidPenal"]);
}
var prm = new object[6];
prm[0] = TrnDate;
prm[1] = CuType;
prm[2] = CuNo;
prm[3] = MemNo;
prm[4] = AccType;
prm[5] = AccNo;
DataTable dt1 = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_CSGetInfoPensionDefaulter", prm, "A2ZCSMCUS");
//DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZDESIGNATION WHERE DesigCode = " + Designcode, "A2ZCSMCUS");
//var p = new A2ZPENSIONDEFAULTERDTO();
if (dt1.Rows.Count > 0)
{
p.TrnDate = Converter.GetDateTime(dt1.Rows[0]["TrnDate"]);
p.CuType = Converter.GetSmallInteger(dt1.Rows[0]["CuType"]);
p.CuNo = Converter.GetInteger(dt1.Rows[0]["CuNo"]);
p.MemNo = Converter.GetInteger(dt1.Rows[0]["MemNo"]);
p.AccType = Converter.GetSmallInteger(dt1.Rows[0]["AccType"]);
p.AccNo = Converter.GetLong(dt1.Rows[0]["AccNo"]);
p.CalDepositAmt = Converter.GetDecimal(dt1.Rows[0]["CalDepositAmt"]);
p.UptoDueDepositAmt = Converter.GetDecimal(dt1.Rows[0]["UptoDueDepositAmt"]);
p.PayableDepositAmt = Converter.GetDecimal(dt1.Rows[0]["PayableDepositAmt"]);
p.PayablePenalAmt = Converter.GetDecimal(dt1.Rows[0]["PayablePenalAmt"]);
p.PaidDepositAmt = Converter.GetDecimal(dt1.Rows[0]["PaidDepositAmt"]);
p.PaidPenalAmt = Converter.GetDecimal(dt1.Rows[0]["PaidPenalAmt"]);
p.CurrDueDepositAmt = Converter.GetDecimal(dt1.Rows[0]["CurrDueDepositAmt"]);
p.DepositFlag = Converter.GetSmallInteger(dt1.Rows[0]["DepositFlag"]);
p.CurrDueDepositAmt = (p.CurrDueDepositAmt - p.CalPaidDeposit);
p.TargetDepositAmt = (p.MthDeposit * p.Period);
if (p.TotalDepositAmt == p.TargetDepositAmt)
{
p.DepositFlag = 1;
}
p.UptoDepositAmt = Converter.GetDecimal(Math.Abs(p.CurrDueDepositAmt));
if (p.UptoDepositAmt > 0)
{
p.DueDepositAmt = (p.UptoDepositAmt - p.CalDepositAmt);
}
else
{
p.DueDepositAmt = 0;
}
p.NoMonth = Converter.GetDecimal(p.TotalDepositAmt / p.MthDeposit);
if (p.NoMonth == 0)
{
p.UptoDate = "";
}
else
{
p.NoMonth = p.NoMonth - 1;
if (p.NoMonth < 1)
{
p.NoMonth = 0;
}
DateTime Depdate = new DateTime();
Depdate = p.Opendate.AddMonths(Converter.GetSmallInteger(p.NoMonth));
p.UptoDate = String.Format("{0:Y}", Depdate);
}
return(p);
}
p.CuType = 0;
return(p);
}
public static A2ZTRNLOGICDTO GetNetEncashmentPension(int BranchNo, Int16 MemType, int MemberNo, int AccType, Int64 AccountNo, DateTime TrnDate)
{
var p = new A2ZTRNLOGICDTO();
A2ZCSPARAMETERDTO dto = A2ZCSPARAMETERDTO.GetParameterValue();
DateTime dt1 = Converter.GetDateTime(dto.ProcessDate);
string date = dt1.ToString("dd/MM/yyyy");
A2ZPENSIONDEFAULTERDTO getDTO = (A2ZPENSIONDEFAULTERDTO.GetPensionDepInformation(BranchNo, TrnDate, MemType, MemberNo, AccType, AccountNo));
if (getDTO.MemType > 0)
{
p.UptoMonth = Converter.GetString(getDTO.UptoMonth);
p.UptoYear = Converter.GetInteger(getDTO.UptoYear);
p.UptoPaidDate = Converter.GetDateTime(getDTO.UptoPaidDate);
p.UptoPaidNo = Converter.GetDecimal(getDTO.UptoPaidNo);
p.DueDepositAmt = Converter.GetDecimal(getDTO.DueDepositAmt);
}
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE BranchNo = '" + BranchNo + "' and AccType = '" + AccType + "' and AccNo = '" +
AccountNo + "' and MemType='" + MemType + "' and MemNo='" + MemberNo + "'", "A2ZACGMS");
if (dt.Rows.Count > 0)
{
p.CalEncashment = Converter.GetDecimal(dt.Rows[0]["CalEncashment"]);
p.LogicAmount = Converter.GetDouble(p.CalEncashment);
p.AccPeriod = Converter.GetInteger(dt.Rows[0]["AccPeriod"]);
p.MthDeposit = Converter.GetDouble(dt.Rows[0]["AccMonthlyDeposit"]);
p.TotalDepAmt = Converter.GetDouble(dt.Rows[0]["AccTotalDep"]);
p.OpenDate = Converter.GetDateTime(dt.Rows[0]["AccOpenDate"]);
//p.NoMonths = Converter.GetDecimal(p.TotalDepAmt / p.MthDeposit);
//if (p.NoMonths == 0)
//{
// p.UptoDate = "";
//}
//else
//{
// p.NoMonths = p.NoMonths - 1;
// if (p.NoMonths < 1)
// {
// p.NoMonths = 0;
// }
// DateTime Depdate = new DateTime();
// Depdate = p.OpenDate.AddMonths(Converter.GetSmallInteger(p.NoMonths));
// p.UptoDate = String.Format("{0:Y}", Depdate);
//}
p.NoRecord = Converter.GetSmallInteger(1);
return(p);
}
else
{
p.NoRecord = 0;
}
return(p);
}
