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);
}
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));
}
public DataTable PopulateUpalabdhi(ProjectUpalabdhiBO obj)
{
Authentication();
return(objBarsikDal.PopulateUpalabdhi(obj));
}
public int InsertUpdateProjectUpalabdhi(ProjectUpalabdhiBO objProjectUpalabdhi)
{
Authentication();
return(objBarsikDal.InsertUpdateProjectUpalabdhi(objProjectUpalabdhi));
}