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); }