public static List <ReleaseLogDetailDataModel> GetEntityDetails(ReleaseLogDetailDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.ReleaseLogDetailSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ReleaseLogId = dataQuery.ReleaseLogId , ReleaseLogDetailId = dataQuery.ReleaseLogDetailId , Feature = dataQuery.Feature , ModuleId = dataQuery.ModuleId , ReleaseFeatureId = dataQuery.ReleaseFeatureId , SystemEntityTypeId = dataQuery.SystemEntityTypeId , PrimaryDeveloper = dataQuery.PrimaryDeveloper , PrimaryEntity = dataQuery.PrimaryEntity , ReleaseIssueTypeId = dataQuery.ReleaseIssueTypeId , ReleasePublishCategoryId = dataQuery.ReleasePublishCategoryId , JIRA = dataQuery.JIRA , UpdatedDateRangeMin = dataQuery.UpdatedDateRangeMin , UpdatedDateRangeMax = dataQuery.UpdatedDateRangeMax , ReturnAuditInfo = returnAuditInfo }; List <ReleaseLogDetailDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <ReleaseLogDetailDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public override int?Save(string action) { var data = new ReleaseLogDetailDataModel(); data.ReleaseLogDetailId = ReleaseLogDetailId; data.ApplicationId = ApplicationId; data.ItemNo = ItemNo; data.Description = Description; data.PrimaryDeveloper = PrimaryDeveloper; data.SortOrder = SortOrder; data.ReleaseIssueTypeId = ReleaseIssueTypeId; data.ReleasePublishCategoryId = ReleasePublishCategoryId; data.Feature = Feature; data.ModuleId = ModuleId; data.ReleaseFeatureId = ReleaseFeatureId; data.JIRA = JIRA; data.PrimaryEntity = PrimaryEntity; data.ReleaseLogId = ReleaseLogId; data.TimeSpent = TimeSpent; data.SystemEntityTypeId = SystemEntityTypeId; //if (drpNewApplicationIdList.Enabled == false) if (drpNewApplicationIdList.SelectedItem.Value == "-1" || drpNewApplicationIdList.SelectedItem.Value == "100") { Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.Save(data, AuditId, action); } else { ReleaseNotesWorkFlow.MoveToApplication(ReleaseLogDetailId.Value, NewApplicationId.Value, AuditId); } // not correct ... when doing insert, we didn't get/change the value of ReleaseLogID ? return(ReleaseLogDetailId); }
public static DataTable GetDetails(ReleaseLogDetailDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile); var table = list.ToDataTable(); return(table); }
public static List <ReleaseLogDetailDataModel> GetList(string prefixText, RequestProfile requestProfile) { var data = new ReleaseLogDetailDataModel() { Feature = prefixText }; return(GetEntityDetails(data, requestProfile, 0)); }
private DataTable GetReleaseLogDetailData(int ReleaseLogId) { var data = new ReleaseLogDetailDataModel(); data.ReleaseLogId = ReleaseLogId; var dt = Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.Search(data, AuditId); return(dt); }
public void LoadData(int releaseLogDetailId, bool showId) { // clear UI Clear(); // set up parameters var data = new ReleaseLogDetailDataModel(); data.ReleaseLogDetailId = releaseLogDetailId; // get data var items = Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.GetEntityDetails(data, AuditId); // should only have single match -- should log exception. if (items.Count != 1) { return; } var item = items[0]; ReleaseLogDetailId = item.ReleaseLogDetailId; ApplicationId = item.ApplicationId; ItemNo = item.ItemNo; Description = item.Description; PrimaryDeveloper = item.PrimaryDeveloper; SortOrder = item.SortOrder; ReleaseIssueTypeId = item.ReleaseIssueTypeId; ReleasePublishCategoryId = item.ReleasePublishCategoryId; Feature = item.Feature; ModuleId = item.ModuleId; ReleaseFeatureId = item.ReleaseFeatureId; JIRA = item.JIRA; PrimaryEntity = item.PrimaryEntity; ReleaseLogId = item.ReleaseLogId; TimeSpent = item.TimeSpent; SystemEntityTypeId = item.SystemEntityTypeId; if (!showId) { txtReleaseLogDetailId.Text = item.ReleaseLogDetailId.ToString(); drpApplicationIdList.Enabled = false; txtApplicationId.Enabled = false; drpNewApplicationIdList.Enabled = true; txtNewApplicationId.Enabled = true; //PlaceHolderAuditHistory.Visible = true; // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup(base.PrimaryEntity, releaseLogDetailId, PrimaryEntityKey); } else { txtReleaseLogDetailId.Text = String.Empty; } oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); }
private System.Data.DataTable GetData() { // TODO: on all export pages var data = new ReleaseLogDetailDataModel(); var dt = Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.Search(data, AuditId); return(dt); }
public static bool DoesExist(ReleaseLogDetailDataModel data, RequestProfile requestProfile) { var doesExistRequest = new ReleaseLogDetailDataModel(); doesExistRequest.ReleaseLogDetailId = data.ReleaseLogDetailId; var list = GetEntityDetails(doesExistRequest, requestProfile, 0); return(list.Count > 0); }
private DataTable GetData(string releaseLogDetailId) { var data = new ReleaseLogDetailDataModel(); data.ReleaseLogDetailId = int.Parse(releaseLogDetailId); var dt = Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.Search(data, AuditId); return(dt); }
public static DataTable DoesExist(ReleaseLogDetailDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.ReleaseLogDetailSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseLogDetailId); var oDt = new DBDataTable("ReleaseLogDetail.DoesExist", sql, DataStoreKey); return(oDt.DBTable); }
public static DataTable GetParentReleaseLogDetailItemList(ReleaseLogDetailDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.ReleaseLogDetailSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId); var oDt = new DBDataTable("ReleaseLogDetail.GetList", sql, DataStoreKey); return(oDt.DBTable); }
public static DataSet ReleaseNotesSearch(ReleaseLogDetailDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.ReleaseNotesSearch" + " " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMax) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMin) + SearchParameter(data, requestProfile); var oDs = new DBDataSet("ReleaseLog.ReleaseNotesSearch", sql, DataStoreKey); return(oDs.DBDataset); }
public static DataTable Search(ReleaseLogDetailDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.ReleaseLogDetailSearch " + " " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseLogDetailId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMax) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMin) + SearchParameter(data, requestProfile); var oDt = new DBDataTable("ReleaseLogDetail.Search", sql, DataStoreKey); return(oDt.DBTable); }
public static void Delete(ReleaseLogDetailDataModel data, RequestProfile requestProfile) { const string sql = @"dbo.ReleaseLogDetailDelete "; var parameters = new { AuditId = requestProfile.AuditId , ReleaseLogDetailId = data.ReleaseLogDetailId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
// What that will do is take a ReleaseLogDetailID clone it and save it with different applicationID. And Delete the original RelaseLogDetail. // Should debug if debug should be real if real. public static void MoveToApplication(int releaseLogDetailId, int applicationId, RequestProfile requestProfile) { var dataItem = new ReleaseLogDetailDataModel(); dataItem.ReleaseLogDetailId = releaseLogDetailId; var oDetail = ReleaseLogDetailDataManager.GetDetails(dataItem, requestProfile); if (oDetail != null) { //copy data from old record dataItem.ApplicationId = oDetail.ApplicationId; dataItem.Application = oDetail.Application; dataItem.ReleaseLog = oDetail.ReleaseLog; dataItem.ReleaseLogId = oDetail.ReleaseLogId; dataItem.ItemNo = oDetail.ItemNo; dataItem.Description = oDetail.Description; dataItem.RequestedBy = oDetail.RequestedBy; dataItem.RequestedDate = oDetail.ReleaseDate; dataItem.PrimaryDeveloper = oDetail.PrimaryDeveloper; dataItem.SortOrder = oDetail.SortOrder; dataItem.ReleaseIssueTypeId = oDetail.ReleaseIssueTypeId; dataItem.ReleasePublishCategoryId = oDetail.ReleasePublishCategoryId; dataItem.ReleaseIssueType = oDetail.ReleaseIssueType; dataItem.ReleasePublishCategory = oDetail.ReleasePublishCategory; dataItem.Feature = oDetail.Feature; dataItem.Module = oDetail.Module; dataItem.ModuleId = oDetail.ModuleId; dataItem.JIRA = oDetail.JIRA; dataItem.PrimaryEntity = oDetail.PrimaryEntity; dataItem.TimeSpent = oDetail.TimeSpent; //delete old record ReleaseLogDetailDataManager.Delete(dataItem, requestProfile); // change application id dataItem.ApplicationId = applicationId; // ReleaseLogDetailId will remain same, only ApplicationId will change ReleaseLogDetailDataManager.Save(dataItem, requestProfile, "Insert"); } }
protected void FillInnerRepeater() { var dtReleaseLog = Framework.Components.ReleaseLog.ReleaseLogDataManager.GetList(SessionVariables.RequestProfile); for (var i = 0; i < dtReleaseLog.Rows.Count; i++) { var releaselogid = int.Parse(dtReleaseLog.Rows[i].ItemArray[0].ToString()); var data = new ReleaseLogDetailDataModel(); data.ReleaseLogId = releaselogid; var dtreleaselogdetails = Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.GetDetails(data, SessionVariables.RequestProfile); Repeater rptr = (Repeater)rptrReleaseLog.Items[i].FindControl("rptrReleaseLogDetails"); if (rptr != null) { rptr.DataSource = dtreleaselogdetails; rptr.DataBind(); } } }
protected override void ShowData(int releaseLogDetailId) { base.ShowData(releaseLogDetailId); oDetailButtonPanel.SetId = SetId; Clear(); var data = new ReleaseLogDetailDataModel(); data.ReleaseLogDetailId = releaseLogDetailId; var items = Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.GetEntityDetails(data, AuditId); // should only have single match if (items.Count == 1) { var item = items[0]; lblReleaseLogDetailId.Text = item.ReleaseLogDetailId.ToString(); lblReleaseLogId.Text = item.ReleaseLog; lblApplicationId.Text = item.Application; lblItemNo.Text = item.ItemNo.ToString(); lblDescription.Text = item.Description; lblRequestedBy.Text = item.RequestedBy.ToString(); lblPrimaryDeveloper.Text = item.PrimaryDeveloper; lblRequestedDate.Text = item.RequestedDate.Value.ToString(SessionVariables.UserDateFormat); lblSortOrder.Text = item.SortOrder.ToString(); lblReleaseIssueType.Text = item.ReleaseIssueType; lblReleasePublishCategory.Text = item.ReleasePublishCategory; lblFeature.Text = item.Feature; lblModule.Text = item.Module; lblReleaseFeature.Text = item.ReleaseFeature; lblJIRA.Text = item.JIRA; lblPrimaryEntity.Text = item.PrimaryEntity; lblSystemEntityType.Text = item.SystemEntityType; lblTimeSpent.Text = item.TimeSpent.ToString(); oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); oHistoryList.Setup(PrimaryEntity, releaseLogDetailId, "ReleaseLogDetail"); } }
protected void btnDelete_Click(object sender, EventArgs e) { try { string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new ReleaseLogDetailDataModel(); data.ReleaseLogDetailId = int.Parse(index); Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.Delete(data, SessionVariables.AuditId); } DeleteAndRedirect(); } catch (Exception ex) { Response.Write(ex.Message); } }
private void InsertDetails() { var data = new ReleaseLogDetailDataModel(); var AuditId = SessionVariables.RequestProfile.AuditId; data.ReleaseLogDetailId = int.Parse(txtReleaseLogDetailId.Text); data.ReleaseLogId = int.Parse(txtReleaseLogId.Text); data.ItemNo = int.Parse(txtItemNo.Text); data.Description = txt_Description.Text; data.SortOrder = int.Parse(txt_SortOrder.Text); Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.Save(data, SessionVariables.RequestProfile, "Insert"); lblMessage.Text = "Record Saved"; lblMessage.Visible = true; txtReleaseLogDetailId.Text = String.Empty; txtItemNo.Text = String.Empty; txt_Description.Text = String.Empty; txt_SortOrder.Text = String.Empty; }
public static string SearchParameter(ReleaseLogDetailDataModel data, RequestProfile requestProfile) { var sql = ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseLogId) + ", " + ToSQLParameter(ReleaseLogDetailDataModel.DataColumns.ApplicationId, data.ApplicationId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.Feature) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ModuleId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseFeatureId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.Description) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.PrimaryEntity) + //", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.SystemEntityTypeId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseIssueTypeId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.JIRA) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMin) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMax); return(sql); }
public static void Save(ReleaseLogDetailDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Insert": data.RequestedBy = "Admin"; data.RequestedDate = DateTime.Now; sql += "dbo.ReleaseLogDetailInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ApplicationId); break; case "Update": sql += "dbo.ReleaseLogDetailUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; } sql += ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseLogDetailId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseLogId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.Feature) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ModuleId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseFeatureId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.SystemEntityTypeId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.PrimaryEntity) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseIssueTypeId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.JIRA) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ItemNo) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.Description) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.SortOrder) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.RequestedDate) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.TimeSpent) + ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.RequestedBy); DBDML.RunSQL("ReleaseLogDetail.Save", sql, DataStoreKey); }
protected override void Clear() { base.Clear(); var data = new ReleaseLogDetailDataModel(); ReleaseLogDetailId = data.ReleaseLogDetailId; ApplicationId = data.ApplicationId; ItemNo = data.ItemNo; Description = data.Description; PrimaryDeveloper = data.PrimaryDeveloper; SortOrder = data.SortOrder; ReleaseIssueTypeId = data.ReleaseIssueTypeId; ReleasePublishCategoryId = data.ReleasePublishCategoryId; Feature = data.Feature; ModuleId = data.ModuleId; ReleaseFeatureId = data.ReleaseFeatureId; JIRA = data.JIRA; PrimaryEntity = data.PrimaryEntity; ReleaseLogId = data.ReleaseLogId; TimeSpent = data.TimeSpent; SystemEntityTypeId = data.SystemEntityTypeId; }
public ResultSet CalculateRNandSDWorkedHours(string emailAddress, int appId) { var rnTotalHours = 0.0; var srnTotalHours = 0.0; var sdTotalHours = 0; var temp = 0.0; var developer = string.Empty; var appUserId = 0; var appUserName = string.Empty; var fromDateTime = new DateTime(); var toDateTime = new DateTime(); var date = new ReleaseLogDetailDataModel(); var dateValue = ReleaseLogDetailDataManager.GetDetails(date, SessionVariables.RequestProfile); var dv = dateValue.DefaultView; dv.Sort = "ReleaseDate ASC"; if (oDateRange.FromDateTime.Equals("") || oDateRange.ToDateTime.Equals("")) { fromDateTime = Convert.ToDateTime(dv.ToTable().Rows[0][ReleaseLogDetailDataModel.DataColumns.ReleaseDate].ToString()); toDateTime = Convert.ToDateTime(dv.ToTable().Rows[dateValue.Rows.Count - 1][ReleaseLogDetailDataModel.DataColumns.ReleaseDate].ToString()); } else { fromDateTime = Convert.ToDateTime(DateTimeHelper.FromUserDateFormatToApplicationDateFormat(oDateRange.FromDateTime)); toDateTime = Convert.ToDateTime(DateTimeHelper.FromUserDateFormatToApplicationDateFormat(oDateRange.ToDateTime)); } var format = SessionVariables.UserDateFormat; var fromDate = fromDateTime.ToString(format); var toDate = toDateTime.ToString(format); //var appObj = new ApplicationDataModel(); //appObj.ApplicationId = appId; //var dt3 = Framework.Components.ApplicationUser.ApplicationDataManager.Search(appObj, SessionVariables.RequestProfile); //var applicationName = dt3.Rows[0][ApplicationDataModel.DataColumns.Name]; var obj1 = new ApplicationUserDataModel(); obj1.EmailAddress = emailAddress; SessionVariables.RequestProfile.ApplicationId = 100; var dt1 = ApplicationUserDataManager.Search(obj1, SessionVariables.RequestProfile); //appUserId = (int)(dt1.Rows[0][ApplicationUserDataModel.DataColumns.ApplicationUserId]); appUserName = dt1.Rows[0][ApplicationUserDataModel.DataColumns.FirstName] + " " + dt1.Rows[0][ApplicationUserDataModel.DataColumns.LastName]; if (dt1.Rows[0][ApplicationUserDataModel.DataColumns.LastName].ToString().Substring(1, 1).Equals("u")) { developer = (string)(dt1.Rows[0][ApplicationUserDataModel.DataColumns.FirstName].ToString().Substring(0, 1) + dt1.Rows[0][ApplicationUserDataModel.DataColumns.LastName].ToString().Substring(0, 1) + "2"); } else { developer = (string)(dt1.Rows[0][ApplicationUserDataModel.DataColumns.FirstName].ToString().Substring(0, 1) + dt1.Rows[0][ApplicationUserDataModel.DataColumns.LastName].ToString().Substring(0, 1)); } var tsObj = new ReleaseLogDetailDataModel(); tsObj.ReleaseDateMin = Convert.ToDateTime(fromDate); tsObj.ReleaseDateMax = Convert.ToDateTime(toDate); tsObj.ApplicationId = appId; tsObj.PrimaryDeveloper = developer; var dt4 = ReleaseLogDetailDataManager.Search(tsObj, SessionVariables.RequestProfile); var temp1 = 0.0; for (var i = 0; i < dt4.Rows.Count; i++) { if (dt4.Rows[i][ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper].Equals(developer) || dt4.Rows[i][ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper].Equals("Admin")) { if (!dt4.Rows[i][ReleaseLogDetailDataModel.DataColumns.TimeSpent].Equals("Unknown")) { temp1 = (double)Convert.ToDouble(dt4.Rows[i][ReleaseLogDetailDataModel.DataColumns.TimeSpent]); srnTotalHours = srnTotalHours + temp1; } } } var sObj = new ApplicationUserDataModel(); sObj.EmailAddress = emailAddress; sObj.ApplicationId = 100047; var sDt = ApplicationUserDataManager.Search(sObj, SessionVariables.RequestProfile); if (sDt.Rows.Count > 0) { var obj2 = new ScheduleDataModel(); obj2.FromSearchDate = Convert.ToDateTime(fromDate); obj2.ToSearchDate = Convert.ToDateTime(toDate); obj2.Person = (sDt.Rows[0][ApplicationUserDataModel.DataColumns.ApplicationUserId]).ToString(); obj2.ApplicationId = 100047; //SessionVariables.RequestProfile.ApplicationId = 100047; var dt2 = ScheduleDataManager.Search(obj2, SessionVariables.RequestProfile); for (var i = 0; i < dt2.Rows.Count; i++) { temp = Convert.ToInt32(dt2.Rows[i][ScheduleDataModel.DataColumns.TotalHoursWorked]); sdTotalHours = sdTotalHours + (int)temp; } } var resultSet = new ResultSet(appUserName, ((int)(rnTotalHours + srnTotalHours)).ToString(), string.Format("{0}.00", sdTotalHours)); return(resultSet); }
public static string ToSQLParameter(ReleaseLogDetailDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ReleaseLogDetailDataModel.DataColumns.ReleaseLogDetailId: if (data.ReleaseLogDetailId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ReleaseLogDetailId, data.ReleaseLogDetailId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseLogDetailId); } break; case ReleaseLogDetailDataModel.DataColumns.ApplicationId: if (data.ApplicationId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ApplicationId, data.ApplicationId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ApplicationId); } break; case ReleaseLogDetailDataModel.DataColumns.ModuleId: if (data.ModuleId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ModuleId, data.ModuleId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ModuleId); } break; case ReleaseLogDetailDataModel.DataColumns.ReleaseFeatureId: if (data.ReleaseFeatureId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ReleaseFeatureId, data.ReleaseFeatureId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseFeatureId); } break; case ReleaseLogDetailDataModel.DataColumns.SystemEntityTypeId: if (data.SystemEntityTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.SystemEntityTypeId); } break; case ReleaseLogDetailDataModel.DataColumns.ReleaseIssueTypeId: if (data.ReleaseIssueTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ReleaseIssueTypeId, data.ReleaseIssueTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseIssueTypeId); } break; case ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId: if (data.ReleasePublishCategoryId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId, data.ReleasePublishCategoryId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId); } break; case ReleaseLogDetailDataModel.DataColumns.ReleaseLogId: if (data.ReleaseLogId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ReleaseLogId, data.ReleaseLogId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseLogId); } break; case ReleaseLogDetailDataModel.DataColumns.ItemNo: if (data.ItemNo != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ItemNo, data.ItemNo); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ItemNo); } break; case ReleaseLogDetailDataModel.DataColumns.SortOrder: if (data.SortOrder != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.SortOrder, data.SortOrder); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.SortOrder); } break; case ReleaseLogDetailDataModel.DataColumns.RequestedDate: if (data.RequestedDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.RequestedDate, data.RequestedDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.RequestedDate); } break; case ReleaseLogDetailDataModel.DataColumns.ReleaseDateMax: if (data.ReleaseDateMax != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMax, data.ReleaseDateMax); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMax); } break; case ReleaseLogDetailDataModel.DataColumns.ReleaseDateMin: if (data.ReleaseDateMin != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMin, data.ReleaseDateMin); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMin); } break; case ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMin: if (data.UpdatedDateRangeMin != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMin, data.UpdatedDateRangeMin); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMin); } break; case ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMax: if (data.UpdatedDateRangeMax != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMax, data.UpdatedDateRangeMax); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMax); } break; case ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper: if (!string.IsNullOrEmpty(data.PrimaryDeveloper)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper, data.PrimaryDeveloper.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper); } break; case ReleaseLogDetailDataModel.DataColumns.PrimaryEntity: if (!string.IsNullOrEmpty(data.PrimaryEntity)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.PrimaryEntity, data.PrimaryEntity); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.PrimaryEntity); } break; case ReleaseLogDetailDataModel.DataColumns.SystemEntityType: if (!string.IsNullOrEmpty(data.SystemEntityType)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.SystemEntityType, data.SystemEntityType); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.SystemEntityType); } break; case ReleaseLogDetailDataModel.DataColumns.JIRA: if (!string.IsNullOrEmpty(data.JIRA)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.JIRA, data.JIRA); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.JIRA); } break; case ReleaseLogDetailDataModel.DataColumns.Feature: if (!string.IsNullOrEmpty(data.Feature)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.Feature, data.Feature); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.Feature); } break; case ReleaseLogDetailDataModel.DataColumns.Module: if (!string.IsNullOrEmpty(data.Module)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.Module, data.Module); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.Module); } break; case ReleaseLogDetailDataModel.DataColumns.ReleaseFeature: if (!string.IsNullOrEmpty(data.ReleaseFeature)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.ReleaseFeature, data.ReleaseFeature); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseFeature); } break; case ReleaseLogDetailDataModel.DataColumns.Description: if (!string.IsNullOrEmpty(data.Description)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.Description, data.Description); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.Description); } break; case ReleaseLogDetailDataModel.DataColumns.TimeSpent: if (!string.IsNullOrEmpty(data.TimeSpent)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.TimeSpent, data.TimeSpent); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.TimeSpent); } break; case ReleaseLogDetailDataModel.DataColumns.RequestedBy: if (!string.IsNullOrEmpty(data.RequestedBy)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.RequestedBy, data.RequestedBy); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.RequestedBy); } break; } return(returnValue); }
public static ReleaseLogDetailDataModel GetDetails(ReleaseLogDetailDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }
public static List <ReleaseLogDetailDataModel> GetParentReleaseLogDetailItemList(ReleaseLogDetailDataModel data, RequestProfile requestProfile) { return(GetEntityDetails(data, requestProfile, 0)); // formulate SQL //var sql = "EXEC dbo.ReleaseLogDetailSearch " + // " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + // ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + // ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId); //var oDt = new DBDataTable("ReleaseLogDetail.GetList", sql, DataStoreKey); //return oDt.DBTable; }