コード例 #1
0
        public DataTable PopulateUpalabdhi(ProjectUpalabdhiBO obj)
        {
            DbCommand cmd = db.GetStoredProcCommand("PKG_PROJECT_BARSIK_KARYEKRAM.PR_SELECT_PRJ_UPALABDHI", obj.ProjectId, obj.FiscalYearId, OracleDbType.RefCursor);
            DataSet   ds  = null;
            DataTable dt  = null;

            ds = db.ExecuteDataSet(cmd);
            if (ds != null && ds.Tables.Count > 0)
            {
                dt = ds.Tables[0];
            }
            return(dt);
        }
コード例 #2
0
        public int InsertUpdateProjectUpalabdhi(ProjectUpalabdhiBO objProjectUpalabdhi)
        {
            int       i   = 0;
            DbCommand cmd = null;

            cmd = db.GetStoredProcCommand("PKG_PROJECT_BARSIK_KARYEKRAM.PR_PROJECT_UPALABDHI");
            db.AddInParameter(cmd, "V_MODE", DbType.String, objProjectUpalabdhi.Mode);
            db.AddInParameter(cmd, "V_UPLABDHI_ID", DbType.Decimal, objProjectUpalabdhi.UplabdhiId);
            db.AddInParameter(cmd, "V_PROJECT_ID", DbType.Decimal, objProjectUpalabdhi.ProjectId);
            db.AddInParameter(cmd, "V_FISCAL_YEAR_ID", DbType.Decimal, objProjectUpalabdhi.FiscalYearId);
            db.AddInParameter(cmd, "V_FIRST_C_DESC", DbType.String, objProjectUpalabdhi.FirstCDesc);
            db.AddInParameter(cmd, "V_SECOND_C_DESC", DbType.String, objProjectUpalabdhi.SecondCDesc);
            db.AddInParameter(cmd, "V_THIRD_C_DESC", DbType.String, objProjectUpalabdhi.ThirdCDesc);
            return(db.ExecuteNonQuery(cmd));
        }
コード例 #3
0
 public DataTable PopulateUpalabdhi(ProjectUpalabdhiBO obj)
 {
     Authentication();
     return(objBarsikDal.PopulateUpalabdhi(obj));
 }
コード例 #4
0
 public int InsertUpdateProjectUpalabdhi(ProjectUpalabdhiBO objProjectUpalabdhi)
 {
     Authentication();
     return(objBarsikDal.InsertUpdateProjectUpalabdhi(objProjectUpalabdhi));
 }