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);
}
