public static A2ZCGLMSTDTO GetOldCodeInformation(int glAccNo)
{
var prm = new object[1];
prm[0] = glAccNo;
DataTable dt = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_GLGetInfoGLOldCode", prm, "A2ZGLCUBS");
//DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZCGLMST WHERE GLAccNo = '" + glAccNo+"'", "A2ZGLMCUS");
var p = new A2ZCGLMSTDTO();
if (dt.Rows.Count > 0)
{
p.Id = Converter.GetSmallInteger(dt.Rows[0]["Id"]);
p.BranchNo = Converter.GetSmallInteger(dt.Rows[0]["BranchNo"]);
p.GLAccType = Converter.GetSmallInteger(dt.Rows[0]["GLAccType"]);
p.GLAccNo = Converter.GetInteger(dt.Rows[0]["GLAccNo"]);
p.GLRecType = Converter.GetSmallInteger(dt.Rows[0]["GLRecType"]);
p.GLPrtPos = Converter.GetSmallInteger(dt.Rows[0]["GLPrtPos"]);
p.GLAccDesc = Converter.GetString(dt.Rows[0]["GLAccDesc"]);
p.GLAccDescB = Converter.GetString(dt.Rows[0]["GLAccDescB"]);
p.GLBgtType = Converter.GetByteValue(dt.Rows[0]["GLBgtType"]);
p.GLOpBal = Converter.GetDecimal(dt.Rows[0]["GLOpBal"]);
p.GLDrSumC = Converter.GetDecimal(dt.Rows[0]["GLDrSumC"]);
p.GLDrSumT = Converter.GetDecimal(dt.Rows[0]["GLDrSumT"]);
p.GLCrSumC = Converter.GetDecimal(dt.Rows[0]["GLCrSumC"]);
p.GLCtSumT = Converter.GetDecimal(dt.Rows[0]["GLCrSumT"]);
p.GLClBal = Converter.GetDecimal(dt.Rows[0]["GLClBal"]);
p.GLHead = Converter.GetInteger(dt.Rows[0]["GLHead"]);
p.GLMainHead = Converter.GetInteger(dt.Rows[0]["GLMainHead"]);
p.GLSubHead = Converter.GetInteger(dt.Rows[0]["GLSubHead"]);
p.GLHeadDesc = Converter.GetString(dt.Rows[0]["GLHeadDesc"]);
p.GLHeadDescB = Converter.GetString(dt.Rows[0]["GLHeadDescB"]);
p.GLMainHeadDesc = Converter.GetString(dt.Rows[0]["GLMainHeadDesc"]);
p.GLMainHeadDescB = Converter.GetString(dt.Rows[0]["GLMainHeadDescB"]);
p.GLSubHeadDesc = Converter.GetString(dt.Rows[0]["GLSubHeadDesc"]);
p.GLSubHeadDescB = Converter.GetString(dt.Rows[0]["GLSubHeadDescB"]);
p.LastVoucherNo = Converter.GetInteger(dt.Rows[0]["LastVoucherNo"]);
p.GLBalanceType = Converter.GetSmallInteger(dt.Rows[0]["GLBalanceType"]);
p.GLMiscAcc = Converter.GetSmallInteger(dt.Rows[0]["GLMiscAcc"]);
p.GLAccMode = Converter.GetSmallInteger(dt.Rows[0]["GLAccMode"]);
p.Status = Converter.GetInteger(dt.Rows[0]["Status"]);
return(p);
}
p.GLAccNo = 0;
return(p);
}
public static int Update1(A2ZCGLMSTDTO dto)
{
int rowEffect = 0;
string strQuery = "UPDATE A2ZCGLMST set GLOpBal='" + dto.GLOpBal + "' where Id='" + dto.Id + "' ";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZGLCUBS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}
public static A2ZCGLMSTDTO GetInformationMainHead(int sub3, int subinputsubhead)
{
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT MAX(GLSubHead)AS GLSubHead FROM A2ZCGLMST WHERE LEFT(GLSubHead,4)='" + subinputsubhead + "'", "A2ZGLCUBS");
var p = new A2ZCGLMSTDTO();
if (dt.Rows.Count > 0)
{
p.GLAccNo = Converter.GetInteger(dt.Rows[0]["GLSubHead"]);
return(p);
}
p.GLAccNo = 0;
return(p);
}
public static int InsertInformation(A2ZCGLMSTDTO dto)
{
int rowEffect = 0;
string strQuery = @"INSERT into A2ZCGLMST(BranchNo,GLAccType,GLAccNo,GLRecType,GLPrtPos,GLAccDesc,GLAccDescB,GLBgtType,GLOpBal,GLDrSumC,GLDrSumT,GLCrSumC,
GLCrSumT,GLClBal,GLHead,GLMainHead,GLSubHead,GLHeadDesc,GLHeadDescB,GLMainHeadDesc,GLMainHeadDescB,GLSubHeadDesc,GLSubHeadDescB,GLBalanceType,GLAccMode,Status,GLMiscAcc) values('" + dto.BranchNo + "','" + dto.GLAccType + "','" + dto.GLAccNo + "','" +
dto.GLRecType + "','" + dto.GLPrtPos + "','" + dto.GLAccDesc + "','" + dto.GLAccDescB + "','" + dto.GLBgtType + "','" + dto.GLOpBal + "','" +
dto.GLDrSumC + "','" + dto.GLDrSumT + "','" + dto.GLCrSumC + "','" + dto.GLCtSumT + "','" + dto.GLClBal + "','" +
dto.GLHead + "','" + dto.GLMainHead + "','" + dto.GLSubHead + "','" + dto.GLHeadDesc + "','" + dto.GLHeadDescB + "','" + dto.GLMainHeadDesc + "','" + dto.GLMainHeadDescB + "','" + dto.GLSubHeadDesc + "','" + dto.GLSubHeadDescB + "','" + dto.GLBalanceType + "','" + dto.GLAccMode + "','" + dto.Status + "','" + dto.GLMiscAcc + "')";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZGLCUBS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}
public static A2ZCGLMSTDTO GetInformationtEST(int glAccNo)
{
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT MAX(GLAccNo) as GLAccNo FROM A2ZCGLMST WHERE LEFT(GLAccNo,5) = '" + glAccNo + "' ", "A2ZGLCUBS");
var p = new A2ZCGLMSTDTO();
if (dt.Rows.Count > 0)
{
p.GLAccNo = Converter.GetInteger(dt.Rows[0]["GLAccNo"]);
return(p);
}
p.GLAccNo = 0;
return(p);
}
