public DataTable GetBulkchange(string username, string upload_id, int IntBulkStatus) { string whereString = ""; if (IntBulkStatus == 1) { whereString += " b.var_lcopre_bulk_useruniqueid= '" + upload_id + "' "; } else if (IntBulkStatus == 2) { whereString += " b. var_lcopre_bulk_useruniqueid= '" + upload_id + "' and b.num_lcopre_bulk_errorcode = '1' "; } else if (IntBulkStatus == 3) { whereString += " b.var_lcopre_bulk_useruniqueid= '" + upload_id + "' and b.num_lcopre_bulk_errorcode = '0' "; } else if (IntBulkStatus == 4) { whereString += " b.var_lcopre_bulk_useruniqueid= '" + upload_id + "' and b.num_lcopre_bulk_errorcode is null and b.var_lcopre_bulk_process_flag='N' "; } Cls_Data_RptBulkActTransProces obj = new Cls_Data_RptBulkActTransProces(); return(obj.GetBulkchange(username, upload_id, IntBulkStatus, whereString)); }
public DataTable GetDetails(string username, string operid, string catid, string Unique_id) { Cls_Data_RptBulkActTransProces obj = new Cls_Data_RptBulkActTransProces(); return(obj.GetDetails(username, operid, catid, Unique_id)); }