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