Exemple #1
0
        //

        //pragati
        public int InsertUpdateProjectBhautikBPragati(ProjectBhautikBPragatiBO objProjectBhautikBPragati)
        {
            int       i   = 0;
            DbCommand cmd = null;

            cmd = db.GetStoredProcCommand("PKG_PROJECT_BARSIK_KARYEKRAM.PR_PROJECT_BHAUTIK_B_PRAGATI");
            db.AddInParameter(cmd, "V_MODE", DbType.String, objProjectBhautikBPragati.Mode);
            db.AddInParameter(cmd, "V_PRAGATI_B_ID", DbType.Decimal, objProjectBhautikBPragati.PragatiBId);
            db.AddInParameter(cmd, "V_FIRST_BHAUTIK_P", DbType.Decimal, objProjectBhautikBPragati.FirstBhautikP);
            db.AddInParameter(cmd, "V_SECOND_BHAUTIK_P", DbType.Decimal, objProjectBhautikBPragati.SecondBhautikP);
            db.AddInParameter(cmd, "V_THIRD_BHAUTIK_P", DbType.Decimal, objProjectBhautikBPragati.ThirdBhautikP);
            db.AddInParameter(cmd, "V_FIRST_BITIYE_P", DbType.Decimal, objProjectBhautikBPragati.FirstBitiyeP);
            db.AddInParameter(cmd, "V_SECOND_BITIYE_P", DbType.Decimal, objProjectBhautikBPragati.SecondBitiyeP);
            db.AddInParameter(cmd, "V_THIRD_BITIYE_P", DbType.Decimal, objProjectBhautikBPragati.ThirdBitiyeP);
            db.AddInParameter(cmd, "V_YES_ABADHI_SAMMA_BHAUTIK", DbType.Decimal, objProjectBhautikBPragati.YesAbadhiSammaBhautik);
            db.AddInParameter(cmd, "V_YES_ABADI_SAMMA_BITIYE", DbType.Decimal, objProjectBhautikBPragati.YesAbadiSammaBitiye);
            db.AddInParameter(cmd, "V_BITEKO_ABADHI", DbType.Decimal, objProjectBhautikBPragati.BitekoAbadhi);
            db.AddInParameter(cmd, "V_PROJECT_ID", DbType.Decimal, objProjectBhautikBPragati.ProjectId);
            db.AddInParameter(cmd, "V_FISCAL_YEAR_ID", DbType.Decimal, objProjectBhautikBPragati.FiscalYearId);
            db.AddInParameter(cmd, "V_YES_ABADHI_SAMMA_BHAUTIK_S", DbType.Decimal, objProjectBhautikBPragati.YesAbadhiSammaBhautikS);
            db.AddInParameter(cmd, "V_YES_ABADHI_SAMMA_BHAUTIK_T", DbType.Decimal, objProjectBhautikBPragati.YesAbadhiSammaBhautikT);
            db.AddInParameter(cmd, "V_BITEKO_ABADHI_S", DbType.Decimal, objProjectBhautikBPragati.BitekoAbadhiS);
            db.AddInParameter(cmd, "V_BITEKO_ABADHI_T", DbType.Decimal, objProjectBhautikBPragati.BitekoAbadhiT);
            db.AddInParameter(cmd, "V_YES_ABADI_SAMMA_BITIYE_S", DbType.Decimal, objProjectBhautikBPragati.YesAbadhiSammaBitiyeS);
            db.AddInParameter(cmd, "V_YES_ABADI_SAMMA_BITIYE_T", DbType.Decimal, objProjectBhautikBPragati.YesAbadhiSammaBitiyeT);
            db.AddInParameter(cmd, "V_MODIFIED_BY", DbType.String, objProjectBhautikBPragati.ModifiedBy);
            db.AddInParameter(cmd, "V_MODIFIED_DATE", DbType.DateTime, objProjectBhautikBPragati.ModifiedDate);

            return(db.ExecuteNonQuery(cmd));
        }
Exemple #2
0
 public int InsertUpdateProjectBhautikBPragati(ProjectBhautikBPragatiBO objProjectBhautikBPragati)
 {
     Authentication();
     return(objBarsikDal.InsertUpdateProjectBhautikBPragati(objProjectBhautikBPragati));
 }