public static void DeleteWorkLog(Guid userId, Guid taskId, DateTime workDate) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@UserId", userId, SqlDbType.UniqueIdentifier); qb.SetInParam("@TaskId", taskId, SqlDbType.UniqueIdentifier); qb.SetInParam("@WorkDate", workDate, SqlDbType.DateTime); qb.ExecuteNonQuery("spDeleteWorkLog"); }
public static void UpdateTodayWorkLog(Guid userId, Guid taskId, decimal hours) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@UserId", userId, SqlDbType.UniqueIdentifier); qb.SetInParam("@TaskId", taskId, SqlDbType.UniqueIdentifier); qb.SetInParam("@Hours", hours, SqlDbType.Decimal); qb.ExecuteNonQuery("spUpdateTodayWorkLog"); }
public static void UpdateComment(string commentId, string comment, string userId) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@CommentId", Guid.Parse(commentId), SqlDbType.UniqueIdentifier); qb.SetInParam("@Comment", comment, SqlDbType.NVarChar); qb.SetInParam("@ModifiedBy", Guid.Parse(userId), SqlDbType.UniqueIdentifier); qb.ExecuteNonQuery("spUpdateComment"); }
public static void UpdateTaskRank(string data, int?status) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.ClearParameters(); qb.SetInParam("@data", data, SqlDbType.NVarChar); qb.SetInParam("@status", status, SqlDbType.Int); qb.ExecuteScalar("spUpdateTaskRank", CommandType.StoredProcedure); }
public static DataTable DownloadAttachment(string attachmentId, string entityId) { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@AttachmentId", Guid.Parse(attachmentId), SqlDbType.UniqueIdentifier); qb.SetInParam("@EntityId", Guid.Parse(entityId), SqlDbType.UniqueIdentifier); ds = qb.ExecuteDataset("spDownloadAttachment2"); return(ds.Tables[0]); }
public static DataSet GetUserWorkLogs(string userId, DateTime dateWorklog) { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@UserId", Guid.Parse(userId), SqlDbType.UniqueIdentifier); qb.SetInParam("@Period", dateWorklog, SqlDbType.DateTime); ds = qb.ExecuteDataset("spGetMonthlyWorkLog"); return(ds); }
public static DataSet GetTodayWorklog(string taskId, string userId) { DataSet ds = null; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@TaskId", Guid.Parse(taskId), SqlDbType.UniqueIdentifier); qb.SetInParam("@UserId", Guid.Parse(userId), SqlDbType.UniqueIdentifier); ds = qb.ExecuteDataset("spGetTodayWorklog"); return(ds); }
public static DataSet CheckAttendanceTime(Guid?employeeId, DateTime?date) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@EmployeeId", employeeId, SqlDbType.UniqueIdentifier); qb.SetInParam("@Date", date, SqlDbType.DateTime); ds = qb.ExecuteDataset("spCheckAttendanceTime"); return(ds); }
public static DataSet GetVersionDetails(Guid?versionId, Guid?taskId = null) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@VersionId", versionId, SqlDbType.UniqueIdentifier); qb.SetInParam("@TaskId", taskId, SqlDbType.UniqueIdentifier); ds = qb.ExecuteDataset("spGetDetailVersionData"); 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 long ImportBulkReleaseNotes(Guid?releaseNoteSummaryId, string selectedVersions) { long result; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@ReleaseNoteSummaryId", releaseNoteSummaryId, SqlDbType.UniqueIdentifier); qb.SetInParam("@SelectedVersions", selectedVersions, SqlDbType.NVarChar); result = qb.ExecuteNonQuery("spGetReference"); return(result); }
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); }
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 void InsertComment(string entityId, int entityType, string commentId, string comment, string userId) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@EntityId", Guid.Parse(entityId), SqlDbType.UniqueIdentifier); qb.SetInParam("@EntityType", entityType, SqlDbType.Int); qb.SetInParam("@Comment", comment, SqlDbType.VarChar); qb.SetInParam("@CreatedBy", Guid.Parse(userId), SqlDbType.UniqueIdentifier); qb.ExecuteNonQuery("spInsertComment"); }
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 long DeleteDeploymentDetails(Guid?versionId, Guid?deploymentSiteId) { long result; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@VersionId", versionId, SqlDbType.UniqueIdentifier); qb.SetInParam("@DeploymentSiteId", deploymentSiteId, SqlDbType.UniqueIdentifier); result = qb.ExecuteNonQuery("spDeleteDeploymentDetail"); return(result); }
public static DataSet GetVersionsForComponentByTaskId(Guid?taskId, string project) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@TaskId", taskId, SqlDbType.UniqueIdentifier); qb.SetInParam("@Project", project, SqlDbType.NVarChar); ds = qb.ExecuteDataset("spGetVersionsForTask"); return(ds); }
public static long LockDBScript(Guid?dBBuildId, bool?isLocked, Guid?modifiedBy) { long result; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@DBBuildId", dBBuildId, SqlDbType.UniqueIdentifier); qb.SetInParam("@IsLocked", isLocked, SqlDbType.Bit); qb.SetInParam("@ModifiedBy", modifiedBy, SqlDbType.UniqueIdentifier); result = qb.ExecuteNonQuery("spUpdateDBBuild"); return(result); }
public static long InsertTaxSavingType(TaxSavingTypeModel taxSavingType) { long result; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.ClearParameters(); qb.SetInParam("@TaxSavingTypeName", taxSavingType.TaxSavingTypeName, SqlDbType.NVarChar); qb.SetInParam("@TaxCategoryCode", taxSavingType.TaxCategoryCode, SqlDbType.NVarChar); result = qb.ExecuteNonQuery("spInsertTaxSavingType", CommandType.StoredProcedure); return(result); }
public static DataTable GetEmployeeTotalLeave(Guid?employeeId, DateTime?leaveDate, int?year) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@EmployeeId", employeeId, SqlDbType.UniqueIdentifier); qb.SetInParam("@LeaveDate", leaveDate, SqlDbType.DateTime); qb.SetInParam("@Year", year, SqlDbType.Int); DataSet ds = qb.ExecuteDataset("spGetEmployeeTotalLeave"); return(ds.Tables[0]); }
public static DataSet GetComponents(Guid?projectId = null, Boolean?isDBComponent = null, Boolean?isVersionComponent = null) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@ProjectId", projectId, SqlDbType.UniqueIdentifier); qb.SetInParam("@IsDBComponent", isDBComponent, SqlDbType.Bit); qb.SetInParam("@IsVersionComponent", isVersionComponent, SqlDbType.Bit); ds = qb.ExecuteDataset("spGetComponentsByType"); return(ds); }
public static int InsertContainer(Container container) { int retStatus = 0; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@ContainerName", container.Name, SqlDbType.NVarChar); qb.SetInParam("@Directories", container.Directories, SqlDbType.NVarChar); retStatus = Convert.ToInt32(qb.ExecuteNonQuery("spInsertContainer")); return(retStatus); }
public static long LockVersion(Guid?versionId, Guid?userId) { long result; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@VersionId", versionId, SqlDbType.UniqueIdentifier); qb.SetInParam("@IsLocked", true, SqlDbType.Bit); qb.SetInParam("@ModifiedBy", userId, SqlDbType.UniqueIdentifier); result = qb.ExecuteNonQuery("spUpdateVersionLock"); return(result); }
public static long InsertNewBuild(Guid?componentId, string name, Guid?createdBy) { long result; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@ComponentId", componentId, SqlDbType.UniqueIdentifier); qb.SetInParam("@Name", name, SqlDbType.NVarChar); qb.SetInParam("@CreatedBy", createdBy, SqlDbType.UniqueIdentifier); result = qb.ExecuteNonQuery("spInsertDBBuild"); return(result); }
public static long InsertOutTime(Guid?employeeId, DateTime?attendanceDate, DateTime?outTime) { long result; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@EmployeeId", employeeId, SqlDbType.UniqueIdentifier); qb.SetInParam("@AttendanceDate", attendanceDate, SqlDbType.DateTime); qb.SetInParam("@OutTime", outTime, SqlDbType.DateTime); result = qb.ExecuteNonQuery("spOutTimeAttendance"); return(result); }
public static int UpdateProjectPermission(string projectId, string userIds) { int retStatus = 0; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@ProjectId", Guid.Parse(projectId), SqlDbType.UniqueIdentifier); qb.SetInParam("@UserIds", userIds, SqlDbType.NVarChar); retStatus = Convert.ToInt32(qb.ExecuteNonQuery("spUpdateProjectPermission")); return(retStatus); }
public static long MoveChanges(Guid?versionId, Guid?versionChangeId, int?status) { long result; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@VersionId", versionId, SqlDbType.UniqueIdentifier); qb.SetInParam("@VersionChangeId", versionChangeId, SqlDbType.UniqueIdentifier); qb.SetInParam("@Status", status, SqlDbType.Int); result = qb.ExecuteNonQuery("spMoveChanges"); return(result); }
public static DataTable GetBuildsBetweenFromAndTo(Guid?componentId, string dBBuildFrom, string dBBuildTo) { DataSet ds; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@ComponentId", componentId, SqlDbType.UniqueIdentifier); qb.SetInParam("@DBBuildFrom", dBBuildFrom, SqlDbType.NVarChar); qb.SetInParam("@DBBuildTo", dBBuildTo, SqlDbType.NVarChar); ds = qb.ExecuteDataset("spGetTotalBuild"); return(ds.Tables[0]); }
public static DataSet GetContainers(bool isAdminRole, string userId) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@IsAdminRole", isAdminRole, SqlDbType.Bit); if (!string.IsNullOrWhiteSpace(userId)) { qb.SetInParam("@UserId", Guid.Parse(userId), SqlDbType.UniqueIdentifier); } return(qb.ExecuteDataset("spGetContainers")); }