public static A2ZGROUPTRNDTO GetSummaryInformation(int memNo, Int16 userId)
{
DataTable dt = new DataTable();
string strQuery = @"SELECT SUM(InputDeposit) AS 'totDeposit',SUM(InputInterest) AS 'totInterest',
SUM(InputPenalty) AS 'totPenalty' FROM A2ZGROUPTRN WHERE MEMNO = " + memNo +
" AND UserId = " + userId;
dt = BLL.CommonManager.Instance.GetDataTableByQuery(strQuery, "A2ZMCUS");
var p = new A2ZGROUPTRNDTO();
if (dt.Rows.Count > 0)
{
p.InputDeposit = Converter.GetDecimal(dt.Rows[0]["totDeposit"]);
p.InputInterest = Converter.GetDecimal(dt.Rows[0]["totInterest"]);
p.InputPenalty = Converter.GetDecimal(dt.Rows[0]["totPenalty"]);
return(p);
}
p.MEMNO = 0;
p.ACCTYPE = 0;
p.ACCNO = 0;
return(p);
}
public static A2ZGROUPTRNDTO GetInformationByID(int id)
{
DataTable dt = new DataTable();
string strQuery = "SELECT * FROM A2ZGROUPTRN WHERE ID='" + id;
dt = BLL.CommonManager.Instance.GetDataTableByQuery(strQuery, "A2ZMCUS");
var p = new A2ZGROUPTRNDTO();
if (dt.Rows.Count > 0)
{
p.ID = Converter.GetInteger(dt.Rows[0]["ID"]);
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.GLACCNO = Converter.GetInteger(dt.Rows[0]["GLACCNO"]);
p.TrnPayType = Converter.GetSmallInteger(dt.Rows[0]["TrnPayType"]);
p.InterestCode = Converter.GetInteger(dt.Rows[0]["InterestCode"]);
p.InterestPayType = Converter.GetSmallInteger(dt.Rows[0]["InterestPayType"]);
p.PenaltyCode = Converter.GetInteger(dt.Rows[0]["PenaltyCode"]);
p.PenaltyPayType = Converter.GetSmallInteger(dt.Rows[0]["PenaltyPayType"]);
p.LRFCode = Converter.GetInteger(dt.Rows[0]["LRFCode"]);
p.LRFPayType = Converter.GetSmallInteger(dt.Rows[0]["LRFPayType"]);
p.OtherCode = Converter.GetInteger(dt.Rows[0]["OtherCode"]);
p.OtherPayType = Converter.GetSmallInteger(dt.Rows[0]["OtherPayType"]);
p.GRPNAME = Converter.GetString(dt.Rows[0]["GRPNAME"]);
p.AtyClass = Converter.GetSmallInteger(dt.Rows[0]["AtyClass"]);
p.BRNO = Converter.GetInteger(dt.Rows[0]["BRNO"]);
p.REGNO = Converter.GetInteger(dt.Rows[0]["REGNO"]);
p.SUBREGNO = Converter.GetInteger(dt.Rows[0]["SUBREGNO"]);
p.COLCODE = Converter.GetInteger(dt.Rows[0]["COLCODE"]);
p.ACCSTAT = Converter.GetSmallInteger(dt.Rows[0]["ACCSTAT"]);
p.ACCBALANCE = Converter.GetDecimal(dt.Rows[0]["ACCBALANCE"]);
p.ACCOPENDT = Converter.GetDateTime(dt.Rows[0]["ACCOPENDT"]);
p.ACCLASTDT = Converter.GetDateTime(dt.Rows[0]["ACCLASTDT"]);
p.ACCINTRATE = Converter.GetDecimal(dt.Rows[0]["ACCINTRATE"]);
p.ACCINSTNO = Converter.GetInteger(dt.Rows[0]["ACCINSTNO"]);
p.ACCINSTAMT = Converter.GetDecimal(dt.Rows[0]["ACCINSTAMT"]);
p.ACC2NDINSTAMT = Converter.GetDecimal(dt.Rows[0]["ACC2NDINSTAMT"]);
p.ACCLASTAMT = Converter.GetDecimal(dt.Rows[0]["ACCLASTAMT"]);
p.ACCMTHDEP = Converter.GetDecimal(dt.Rows[0]["ACCMTHDEP"]);
p.CalDeposit = Converter.GetDecimal(dt.Rows[0]["CalDeposit"]);
p.CalInterest = Converter.GetDecimal(dt.Rows[0]["CalInterest"]);
p.CalPenalty = Converter.GetDecimal(dt.Rows[0]["CalPenalty"]);
p.CalOther = Converter.GetDecimal(dt.Rows[0]["CalOther"]);
p.InputDeposit = Converter.GetDecimal(dt.Rows[0]["InputDeposit"]);
p.InputInterest = Converter.GetDecimal(dt.Rows[0]["InputInterest"]);
p.InputPenalty = Converter.GetDecimal(dt.Rows[0]["InputPenalty"]);
p.InputOther = Converter.GetDecimal(dt.Rows[0]["InputOther"]);
p.UserId = Converter.GetSmallInteger(dt.Rows[0]["UserId"]);
p.BoothCode = Converter.GetSmallInteger(dt.Rows[0]["BoothCode"]);
p.CreateDate = Converter.GetDateTime(dt.Rows[0]["CreateDate"]);
return(p);
}
p.MEMNO = 0;
p.ACCTYPE = 0;
p.ACCNO = 0;
return(p);
}
public static int UpdateGroupTransaction(A2ZGROUPTRNDTO grpTrnDto)
{
int result = 0;
string strQuery = "UPDATE A2ZGROUPTRN SET InputDeposit = " + grpTrnDto.InputDeposit + ",InputInterest = " + grpTrnDto.InputInterest +
",InputPenalty = " + grpTrnDto.InputPenalty + " WHERE ID = " + grpTrnDto.ID;
result = Converter.GetInteger(CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZMCUS"));
return(result);
}