//public static int InsertInformation(A2ZCASHCODECTLRDTO dto)
//{
// int rowEffect = 0;
// string strQuery = @"INSERT into A2ZCGLMST(AccStatusCode,AccStatusDescription)values('" + dto.AccStatusCode + "','" + dto.AccStatusDescription + "')";
// rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSMCUS"));
// if (rowEffect == 0)
// {
// return 0;
// }
// else
// {
// return 1;
// }
//}
public static A2ZCASHCODECTLRDTO GetInformation(Int16 cashcode)
{
var prm = new object[1];
prm[0] = cashcode;
DataTable dt = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_GLGetInfoCashCodeCtrl", prm, "A2ZGLMCUS");
//DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZCGLMST WHERE GLAccNo = " + cashcode, "A2ZGLMCUS");
var p = new A2ZCASHCODECTLRDTO();
if (dt.Rows.Count > 0)
{
p.CashCode = Converter.GetInteger(dt.Rows[0]["GLAccNo"]);
p.LastVoucherNo = Converter.GetInteger(dt.Rows[0]["LastVoucherNo"]);
return(p);
}
p.CashCode = 0;
return(p);
}
public static int UpdateInformation(A2ZCASHCODECTLRDTO dto)
{
int rowEffect = 0;
string strQuery = "UPDATE A2ZCGLMST set GLAccNo='" + dto.CashCode + "', LastVoucherNo='" + dto.LastVoucherNo + "' where GLAccNo='" + dto.CashCode + "'";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZGLMCUS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}