public static A2ZGLPARAMETERDTO GetParameterValue()
{
A2ZGLPARAMETERDTO p = new A2ZGLPARAMETERDTO();
DataTable dt = CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZGLPARAMETER", "A2ZGLMCUS");
p.FinancialMonth = Utility.Converter.GetSmallInteger(dt.Rows[0]["FinancialMonth"]);
p.FinancialBegYear = Utility.Converter.GetSmallInteger(dt.Rows[0]["FinancialBegYear"]);
p.FinancialEndYear = Utility.Converter.GetSmallInteger(dt.Rows[0]["FinancialEndYear"]);
p.CurrentMonth = Utility.Converter.GetSmallInteger(dt.Rows[0]["CurrentMonth"]);
p.CurrentYear = Utility.Converter.GetSmallInteger(dt.Rows[0]["CurrentYear"]);
p.LastVoucherNo = Utility.Converter.GetString(dt.Rows[0]["LastVoucherNo"]);
p.LastUpdateDate = Utility.Converter.GetDateTime(dt.Rows[0]["LastUpdateDate"]);
p.NumberOfUser = Utility.Converter.GetSmallInteger(dt.Rows[0]["NumberOfUser"]);
p.SingleUserFlag = Utility.Converter.GetSmallInteger(dt.Rows[0]["SingleUserFlag"]);
p.ProcessDate = Utility.Converter.GetDateTime(dt.Rows[0]["ProcessDate"]);
p.ProcessStatus = Utility.Converter.GetSmallInteger(dt.Rows[0]["ProcessStatus"]);
p.BackupStatus = Utility.Converter.GetSmallInteger(dt.Rows[0]["BackupStatus"]);
p.InstallDate = Utility.Converter.GetDateTime(dt.Rows[0]["InstallDate"]);
p.UDPLCode = Utility.Converter.GetInteger(dt.Rows[0]["UnDisPLGLCode"]);
p.PLCode = Utility.Converter.GetInteger(dt.Rows[0]["PLGLCode"]);
p.CashCode = Utility.Converter.GetInteger(dt.Rows[0]["CashCode"]);
p.ApprovBy = Utility.Converter.GetSmallInteger(dt.Rows[0]["ApprovBy"]);
p.ApprovByDate = Utility.Converter.GetDateTime(dt.Rows[0]["ApprovByDate"]);
return(p);
}
public static int UpdateInformation(A2ZGLPARAMETERDTO dto)
{
int rowEffect = 0;
string strQuery = "UPDATE A2ZGLPARAMETER SET FinancialMonth='" + dto.FinancialMonth + "',PLGLCode='" + dto.PLCode + "',UnDisPLGLCode='" + dto.UDPLCode + "'";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZGLMCUS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}