public static DataSet GetTasks(string projectId, string status, string taskType = "", string component = "", string assignees = "", int isBoard = 0) { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@ProjectId", Guid.Parse(projectId), SqlDbType.UniqueIdentifier); if (!string.IsNullOrEmpty(status)) { qb.SetInParam("@Status", status, SqlDbType.VarChar); } if (!string.IsNullOrEmpty(taskType)) { qb.SetInParam("@TaskType", taskType, SqlDbType.VarChar); } if (!string.IsNullOrEmpty(component)) { qb.SetInParam("@Component", component, SqlDbType.VarChar); } if (!string.IsNullOrEmpty(assignees)) { qb.SetInParam("@Assignees", assignees, SqlDbType.VarChar); } qb.SetInParam("@IsBoard", isBoard, SqlDbType.Bit); ds = qb.ExecuteDataset("spGetTasks"); return(ds); }
public static DataTable UpcomingLeaves() { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); DataSet ds = qb.ExecuteDataset("spGetUpcomingLeaves"); return(ds.Tables[0]); }
public static DataTable EmployeeLeaveRecord(string isAdmin, Guid?employeeId) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); if (isAdmin == "1") { ds = qb.ExecuteDataset("spGetEmployeeLeaveCount"); } else { qb.SetInParam("@EmployeeId", employeeId, SqlDbType.UniqueIdentifier); ds = qb.ExecuteDataset("spGetEmployeeLeaveCount"); } return(ds.Tables[0]); }
public static DataSet GetConfigValue() { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); DataSet ds = qb.ExecuteDataset("spGetConfigValue", CommandType.StoredProcedure); return(ds); }
public static DataSet GetEmailTemplates() { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); ds = qb.ExecuteDataset("GetEmailTemplates"); return(ds); }
public static DataSet GetProjectSummary() { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); ds = qb.ExecuteDataset("spGetProjectSummary"); return(ds); }
public static DataSet GetTaxSavingType() { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); ds = qb.ExecuteDataset("spGetTaxSavingTypes"); return(ds); }
public static DataSet GetClients() { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); ds = qb.ExecuteDataset("spSelectActiveClient"); return(ds); }
public static DataSet GetUsers() { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); ds = qb.ExecuteDataset("spGetDistinctUserName"); return(ds); }
public static DataSet GetResourceWorkload() { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); ds = qb.ExecuteDataset("spGetResourceWorkload"); return(ds); }
public static DataSet GetEmployees() { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@EmployeeId", DBNull.Value, SqlDbType.UniqueIdentifier); DataSet ds = qb.ExecuteDataset("spGetEmployee", CommandType.StoredProcedure); return(ds); }
public static DataSet GetReleaseNotes(string releaseNoteSummaryIds) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@ReleaseNoteSummaryIds", releaseNoteSummaryIds, SqlDbType.NVarChar); ds = qb.ExecuteDataset("spGetReleaseNoteBySummaryId"); return(ds); }
public static DataSet GetProjectWorkLogs(DateTime dateWorklog) { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@Period", dateWorklog, SqlDbType.DateTime); ds = qb.ExecuteDataset("spGetMonthlyWorkLogProject"); return(ds); }
public static DataSet GetDeploymentDetail(Guid?versionId) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@VersionId", versionId, SqlDbType.UniqueIdentifier); ds = qb.ExecuteDataset("spGetBuildDetail"); return(ds); }
public static DataSet GetAllProjects(string userId) { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@UserId", Guid.Parse(userId), SqlDbType.UniqueIdentifier); ds = qb.ExecuteDataset("spGetAssignedProject"); return(ds); }
public static DataSet GetAttachments(string taskId) { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@TaskId", Guid.Parse(taskId), SqlDbType.UniqueIdentifier); ds = qb.ExecuteDataset("spGetAttachments"); return(ds); }
public static DataSet GetStatus(int entityType) { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@EntityType", entityType, SqlDbType.Int); ds = qb.ExecuteDataset("spGetStatus"); return(ds); }
public static DataSet GetTaskTypes(int categoryId) { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@CategoryId", categoryId, SqlDbType.Int); ds = qb.ExecuteDataset("GetTypes"); return(ds); }
public static DataSet GetMyTasks(string assignee) { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@Assignee", Guid.Parse(assignee), SqlDbType.UniqueIdentifier); ds = qb.ExecuteDataset("spGetMyTasks"); return(ds); }
public static DataSet LeaveReport(string employeeStatus) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@EmployeeStatus", employeeStatus, SqlDbType.NVarChar); DataSet ds = qb.ExecuteDataset("spGetEmployeeLeaveRecord"); return(ds); }
public static DataTable GetAllDBScriptsByComponent(string componentId) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@DBBuildId", componentId, SqlDbType.NVarChar); ds = qb.ExecuteDataset("spGetAllDBScriptsByComponent"); return(ds.Tables[0]); }
public static DataSet GetAttendanceReport(DateTime?reportDate) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@Period", reportDate, SqlDbType.DateTime); ds = qb.ExecuteDataset("spGetEmployeeAttendance"); return(ds); }
public static DataSet GetUserByRole(string roleName) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@RoleName", roleName, SqlDbType.NVarChar); ds = qb.ExecuteDataset("spGetUsersByRoleName"); return(ds); }
public static DataSet GetDBScriptSummary(Guid?dBBuildId) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@DBBuildId", dBBuildId, SqlDbType.UniqueIdentifier); ds = qb.ExecuteDataset("spSelectDBScript"); return(ds); }
public static DataSet GetBuilds(Guid?componentId) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@ComponentId", componentId, SqlDbType.UniqueIdentifier); ds = qb.ExecuteDataset("spGetDBBuilds"); return(ds); }
public static DataSet GetTaxSavingReceiptForExcel(Guid?employeeId, int finacialYear) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@EmployeeId", employeeId, SqlDbType.UniqueIdentifier); qb.SetInParam("@FinancialYear", finacialYear, SqlDbType.Int); ds = qb.ExecuteDataset("spGetTaxSavingReceiptExcel"); return(ds); }
public static DataSet GetDBScriptsBySearchText(Guid?componentId, string searchText) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@ComponentId", componentId, SqlDbType.UniqueIdentifier); qb.SetInParam("@SearchText", searchText, SqlDbType.NVarChar); ds = qb.ExecuteDataset("spGetScriptsByComponentAndName"); return(ds); }
public static DataSet GetTypes(int?entityType, string optionSetName) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@EntityType", entityType, SqlDbType.Int); qb.SetInParam("@OptionSetName", optionSetName, SqlDbType.NVarChar); ds = qb.ExecuteDataset("spGetOptions"); return(ds); }
public static DataSet CopyTaxSavingData(Guid EmployeeId, int FinancialPriviousYear) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@EmployeeId", EmployeeId, SqlDbType.UniqueIdentifier); qb.SetInParam("@FinancialPriviousYear", FinancialPriviousYear, SqlDbType.Int); DataSet ds = qb.ExecuteDataset("spCopyTaxSavingData", CommandType.StoredProcedure); return(ds); }
public static DataSet GetComments(int entityType, string taskId) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@EntityType", entityType, SqlDbType.Int); qb.SetInParam("@EntityId", Guid.Parse(taskId), SqlDbType.UniqueIdentifier); var ds = qb.ExecuteDataset("spGetComments"); return(ds); }