public static A2ZPENSIONDTO GetInformation(int accType, Int16 SlabFlag, double depAmount, Int16 period)
{
DataTable dt = new DataTable();
string strQuery = "SELECT * FROM A2ZATYSLAB WHERE AtyAccType = '" + accType + "' and AtyFlag = '" + SlabFlag + "' AND AtyRecords='" + depAmount + "'";
if (period != 0)
{
strQuery = strQuery + " AND AtyPeriod = " + period;
}
dt = BLL.CommonManager.Instance.GetDataTableByQuery(strQuery, "A2ZCSCUBS");
var p = new A2ZPENSIONDTO();
if (dt.Rows.Count > 0)
{
p.AccType = Converter.GetInteger(dt.Rows[0]["AtyAccType"]);
p.DepositeAmount = Converter.GetDecimal(dt.Rows[0]["AtyRecords"]);
p.Period = Converter.GetSmallInteger(dt.Rows[0]["AtyPeriod"]);
p.MaturedAmount = Converter.GetDecimal(dt.Rows[0]["AtyMaturedAmt"]);
p.InterestRate = Converter.GetDecimal(dt.Rows[0]["AtyIntRate"]);
p.NoRecord = 1;
return(p);
}
p.AccType = 0;
p.DepositeAmount = 0;
p.Period = 0;
p.MaturedAmount = 0;
p.InterestRate = 0;
p.NoRecord = 0;
return(p);
}
public static A2ZPENSIONDTO PGetInformation(int AccType, Int16 SlabFlag, double Record, Int16 period)
{
string strQuery = "SELECT * FROM A2ZATYSLAB WHERE AtyAccType='" + AccType + "' and AtyFlag = '" + SlabFlag + "' and AtyRecords = '" + Record + "' AND AtyPeriod='" + period + "'";
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery(strQuery, "A2ZCSCUBS");
var p = new A2ZPENSIONDTO();
if (dt.Rows.Count > 0)
{
p.AccType = Converter.GetInteger(dt.Rows[0]["AtyAccType"]);
//p.Date = Converter.GetDateTime(dt.Rows[0]["AtyDate"]);
p.SlabFlag = Converter.GetSmallInteger(dt.Rows[0]["AtyFlag"]);
p.DepositeAmount = Converter.GetDecimal(dt.Rows[0]["AtyRecords"]);
p.Period = Converter.GetSmallInteger(dt.Rows[0]["AtyPeriod"]);
p.MaturedAmount = Converter.GetDecimal(dt.Rows[0]["AtyMaturedAmt"]);
p.InterestRate = Converter.GetDecimal(dt.Rows[0]["AtyIntRate"]);
p.BonusAmount = Converter.GetDecimal(dt.Rows[0]["AtyBonusAmt"]);
p.PenalAmount = Converter.GetDecimal(dt.Rows[0]["AtyPenalAmt"]);
p.NoRecord = 1;
return(p);
}
p.AccType = 0;
p.SlabFlag = 0;
p.DepositeAmount = 0;
p.Period = 0;
p.MaturedAmount = 0;
p.InterestRate = 0;
p.NoRecord = 0;
return(p);
}
public static int UpdateInformation(A2ZPENSIONDTO dto)
{
int rowEffect = 0;
string strQuery = "UPDATE A2ZATYSLAB set AtyFlag='" + dto.SlabFlag + "',AtyRecords='" + dto.DepositeAmount + "',AtyPeriod='" + dto.Period + "',AtyMaturedAmt='" + dto.MaturedAmount + "',AtyIntRate='" + dto.InterestRate + "',AtyPenalAmt='" + dto.PenalAmount + "',AtyBonusAmt='" + dto.BonusAmount + "' where AtyFlag='" + dto.SlabFlag + "' and AtyAccType='" + dto.AccType + "' and AtyRecords='" + dto.DepositeAmount + "' and AtyPeriod='" + dto.Period + "'";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSCUBS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}
} // 1= Record Found, 0=No Record Found
#endregion
public static int InsertInformation(A2ZPENSIONDTO dto)
{
int rowEffect = 0;
string strQuery1 = @"INSERT into A2ZATYSLAB(AtyAccType,AtyFlag,AtyRecords,AtyPeriod,AtyMaturedAmt,AtyIntRate,AtyPenalAmt,AtyBonusAmt)
values('" + dto.AccType + "','" + dto.SlabFlag + "','" + dto.DepositeAmount + "','" + dto.Period + "','" +
dto.MaturedAmount + "','" + dto.InterestRate + "','" + dto.PenalAmount + "','" + dto.BonusAmount + "')";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery1, "A2ZCSCUBS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}
