public DataSet MigrationInsUpd(clsMigration objMigration)
{
dataAccess = new DataAccess();
DataSet ds = new DataSet();
Object[] parametes = new Object[] {
objMigration.MigrationFilesID,
objMigration.MigrationTypeID,
objMigration.Action,
objMigration.FileName,
objMigration.FileType,
objMigration.TabName,
objMigration.TotalNoOfRecords,
objMigration.FailedRecords,
objMigration.UploadedPath,
objMigration.UploadDate,
objMigration.Status,
objMigration.IsProcessed,
objMigration.ProcessedDate,
objMigration.UploadedBy,
objMigration.LastUpdatedBy,
objMigration.LastUpdatedDate
};
ds = dataAccess.LoadDataSet(parametes, "P_MIG_MigrationFiles_INS_UPD", "MigrationInsUpd");
return(ds);
}
public DataSet MigrationBillingWoClosingSlipInsUpd(clsMigration objMigration)
{
dataAccess = new DataAccess();
DataSet ds = new DataSet();
Object[] parametes = new Object[] {
objMigration.BatchRefNo,
objMigration.Action,
objMigration.FileName,
objMigration.FileType,
objMigration.TotalNoOfRecords,
objMigration.FailedRecords,
objMigration.SuccessRecords,
objMigration.UploadedPath,
objMigration.UploadDate,
objMigration.Status,
objMigration.IsProcessed,
objMigration.ProcessedDate,
objMigration.UploadedBy,
objMigration.LastUpdatedBy,
objMigration.LastUpdatedDate
};
ds = dataAccess.LoadDataSet(parametes, "P_MIG_MigrationBillingWoClosingSlip_INS_UPD", "MigrationInsUpd");
return(ds);
}
public DataSet GetMigration(clsMigration objMigration)
{
dataAccess = new DataAccess();
DataSet ds = new DataSet();
Object[] parametes = new Object[] {
objMigration.MigrationFilesID,
};
ds = dataAccess.LoadDataSet(parametes, "P_MIG_MigrationFiles_SEL", "MigrationSelect");
return(ds);
}
public DataSet GetMigrationBillingWoClosingSlip(clsMigration objMigration)
{
dataAccess = new DataAccess();
DataSet ds = new DataSet();
Object[] parametes = new Object[] {
objMigration.BatchRefNo,
objMigration.FileName,
objMigration.UploadDate
};
ds = dataAccess.LoadDataSet(parametes, "P_MIG_MigrationBillingWoClosingSlip_SEL", "MigrationSelect");
return(ds);
}