public static int UpdateInformation01(A2ZLOANDEFAULTERDTO dto)
{
var prm = new object[11];
prm[0] = dto.BranchNo;
prm[1] = dto.AccType;
prm[2] = dto.AccNo;
prm[3] = dto.MemType;
prm[4] = dto.MemNo;
prm[5] = dto.PayablePrincAmt;
prm[6] = dto.PayableIntAmt;
prm[7] = dto.CurrDuePrincAmt;
prm[8] = dto.CurrDueIntAmt;
prm[9] = dto.UserId;
prm[10] = dto.TrnDate;
BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_CSLoanAccountDefaulterDataUpdate", prm, "A2ZACGMS");
return(0);
//int rowEffect = 0;
//string strQuery = "UPDATE A2ZLOANDEFAULTER set PayablePrincAmt='" + dto.PayablePrincAmt + "',PayableIntAmt='" + dto.PayableIntAmt + "', CurrDuePrincAmt='" + dto.CurrDuePrincAmt + "',CurrDueIntAmt='" + dto.CurrDueIntAmt + "' where BranchNo='" + dto.BranchNo + "' and TrnDate='" + dto.TrnDate + "' and MemType='" + dto.MemType + "' and MemNo='" + dto.MemNo + "' and AccType='" + dto.AccType + "' and AccNo='" + dto.AccNo + "'";
//rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZACGMS"));
//if (rowEffect == 0)
//{
// return 0;
//}
//else
//{
// return 1;
//}
}
public static A2ZLOANDEFAULTERDTO GetLoanInformation(int BranchNo, DateTime TrnDate, Int16 MemType, int MemNo, int AccType, Int64 AccNo)
{
var prm = new object[6];
prm[0] = BranchNo;
prm[1] = TrnDate;
prm[2] = MemType;
prm[3] = MemNo;
prm[4] = AccType;
prm[5] = AccNo;
DataTable dt = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_CSGetInfoLoanDefaulter", prm, "A2ZACGMS");
//DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZDESIGNATION WHERE DesigCode = " + Designcode, "A2ZCSMCUS");
var p = new A2ZLOANDEFAULTERDTO();
if (dt.Rows.Count > 0)
{
p.ID = Converter.GetInteger(dt.Rows[0]["ID"]);
p.TrnDate = Converter.GetDateTime(dt.Rows[0]["TrnDate"]);
p.MemType = Converter.GetSmallInteger(dt.Rows[0]["MemType"]);
p.MemNo = Converter.GetInteger(dt.Rows[0]["MemNo"]);
p.AccType = Converter.GetSmallInteger(dt.Rows[0]["AccType"]);
p.AccNo = Converter.GetLong(dt.Rows[0]["AccNo"]);
p.CalPrincAmt = Converter.GetDecimal(dt.Rows[0]["CalPrincAmt"]);
p.CalIntAmt = Converter.GetDecimal(dt.Rows[0]["CalIntAmt"]);
p.UptoDuePrincAmt = Converter.GetDecimal(dt.Rows[0]["UptoDuePrincAmt"]);
p.UptoDueIntAmt = Converter.GetDecimal(dt.Rows[0]["UptoDueIntAmt"]);
p.PayablePrincAmt = Converter.GetDecimal(dt.Rows[0]["PayablePrincAmt"]);
p.PayableIntAmt = Converter.GetDecimal(dt.Rows[0]["PayableIntAmt"]);
p.PayablePenalAmt = Converter.GetDecimal(dt.Rows[0]["PayablePenalAmt"]);
p.PaidPrincAmt = Converter.GetDecimal(dt.Rows[0]["PaidPrincAmt"]);
p.PaidIntAmt = Converter.GetDecimal(dt.Rows[0]["PaidIntAmt"]);
p.PaidPenalAmt = Converter.GetDecimal(dt.Rows[0]["PaidPenalAmt"]);
p.CurrDuePrincAmt = Converter.GetDecimal(dt.Rows[0]["CurrDuePrincAmt"]);
p.CurrDueIntAmt = Converter.GetDecimal(dt.Rows[0]["CurrDueIntAmt"]);
p.UptoPaidDate = Converter.GetDateTime(dt.Rows[0]["UptoPaidDate"]);
return(p);
}
p.MemType = 0;
return(p);
}
public static int UpdateInformation01(A2ZLOANDEFAULTERDTO dto)
{
var prm = new object[7];
prm[0] = dto.TrnDate;
prm[1] = dto.CuType;
prm[2] = dto.CuNo;
prm[3] = dto.MemNo;
prm[4] = dto.AccType;
prm[5] = dto.AccNo;
prm[6] = dto.CurrDueIntAmt;
BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_CSLoanAccountDefaulterDataUpdate", prm, "A2ZCSMCUS");
return(0);
}
public static A2ZLOANDEFAULTERDTO GetLoanInformation(DateTime TrnDate, Int16 CuType, int CuNo, int MemNo, int AccType, Int64 AccNo)
{
var prm1 = new object[1];
prm1[0] = AccNo;
DataTable dt0 = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_CSGenerateTodaysLoanDeposit", prm1, "A2ZCSMCUS");
DataTable dt1 = 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 A2ZLOANDEFAULTERDTO();
if (dt1.Rows.Count > 0)
{
p.CalPaidDeposit = Converter.GetDecimal(dt1.Rows[0]["CalPaidDeposit"]);
p.CalPaidInterest = Converter.GetDecimal(dt1.Rows[0]["CalPaidInterest"]);
p.CalPaidPenal = Converter.GetDecimal(dt1.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 dt = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_CSGetInfoLoanDefaulter", prm, "A2ZCSMCUS");
//DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZDESIGNATION WHERE DesigCode = " + Designcode, "A2ZCSMCUS");
if (dt.Rows.Count > 0)
{
p.TrnDate = Converter.GetDateTime(dt.Rows[0]["TrnDate"]);
p.CuType = Converter.GetSmallInteger(dt.Rows[0]["CuType"]);
p.CuNo = Converter.GetInteger(dt.Rows[0]["CuNo"]);
p.MemNo = Converter.GetInteger(dt.Rows[0]["MemNo"]);
p.AccType = Converter.GetSmallInteger(dt.Rows[0]["AccType"]);
p.AccNo = Converter.GetLong(dt.Rows[0]["AccNo"]);
p.CalPrincAmt = Converter.GetDecimal(dt.Rows[0]["CalPrincAmt"]);
p.CalIntAmt = Converter.GetDecimal(dt.Rows[0]["CalIntAmt"]);
p.UptoDuePrincAmt = Converter.GetDecimal(dt.Rows[0]["UptoDuePrincAmt"]);
p.UptoDueIntAmt = Converter.GetDecimal(dt.Rows[0]["UptoDueIntAmt"]);
p.PayablePrincAmt = Converter.GetDecimal(dt.Rows[0]["PayablePrincAmt"]);
p.PayableIntAmt = Converter.GetDecimal(dt.Rows[0]["PayableIntAmt"]);
p.PayablePenalAmt = Converter.GetDecimal(dt.Rows[0]["PayablePenalAmt"]);
p.PaidPrincAmt = Converter.GetDecimal(dt.Rows[0]["PaidPrincAmt"]);
p.PaidIntAmt = Converter.GetDecimal(dt.Rows[0]["PaidIntAmt"]);
p.PaidPenalAmt = Converter.GetDecimal(dt.Rows[0]["PaidPenalAmt"]);
p.CurrDuePrincAmt = Converter.GetDecimal(dt.Rows[0]["CurrDuePrincAmt"]);
p.CurrDueIntAmt = Converter.GetDecimal(dt.Rows[0]["CurrDueIntAmt"]);
p.CurrDuePrincAmt = (p.CurrDuePrincAmt - p.CalPaidDeposit);
p.CurrDueIntAmt = (p.CurrDueIntAmt - p.CalPaidInterest);
return(p);
}
p.CuType = 0;
return(p);
}
