protected override void Update(Dictionary <string, string> values) { var data = new ScheduleItemDataModel(); if (values.ContainsKey(ScheduleItemDataModel.DataColumns.ScheduleItemId)) { data.ScheduleItemId = int.Parse(values[ScheduleItemDataModel.DataColumns.ScheduleItemId].ToString()); } if (values.ContainsKey(ScheduleItemDataModel.DataColumns.ScheduleId)) { data.ScheduleId = int.Parse(values[ScheduleItemDataModel.DataColumns.ScheduleId].ToString()); } if (values.ContainsKey(ScheduleItemDataModel.DataColumns.TaskFormulationId)) { data.TaskFormulationId = int.Parse(values[ScheduleItemDataModel.DataColumns.TaskFormulationId].ToString()); } if (values.ContainsKey(ScheduleItemDataModel.DataColumns.TotalTimeSpent)) { data.TotalTimeSpent = decimal.Parse(values[ScheduleItemDataModel.DataColumns.TotalTimeSpent].ToString()); } TaskTimeTracker.Components.Module.TimeTracking.ScheduleItemDataManager.Update(data, SessionVariables.RequestProfile); base.Update(values); }
protected override void ShowData(int scheduleItemId) { base.ShowData(scheduleItemId); oDetailButtonPanel.SetId = SetId; Clear(); var dataQuery = new ScheduleItemDataModel(); dataQuery.ScheduleItemId = scheduleItemId; var entityList = TaskTimeTracker.Components.Module.TimeTracking.ScheduleItemDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile); if (entityList.Count == 1) { foreach (var entityItem in entityList) { lblScheduleItemId.Text = entityItem.ScheduleItemId.ToString(); lblScheduleId.Text = entityItem.ScheduleId.ToString(); lblTaskFormulationId.Text = entityItem.TaskFormulationId.ToString(); lblTotalTimeSpent.Text = entityItem.TotalTimeSpent.ToString(); oUpdateInfo.LoadText(entityItem.UpdatedDate, entityItem.UpdatedBy, entityItem.LastAction); oHistoryList.Setup(PrimaryEntity, scheduleItemId, "ScheduleItem"); } } }
public static List <ScheduleItemDataModel> GetEntityDetails(ScheduleItemDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.ScheduleItemSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ScheduleItemId = dataQuery.ScheduleItemId , ReturnAuditInfo = returnAuditInfo , ApplicationMode = requestProfile.ApplicationModeId , ScheduleId = dataQuery.ScheduleId , TaskFormulationId = dataQuery.TaskFormulationId }; List <ScheduleItemDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <ScheduleItemDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
private static string Save(ScheduleItemDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.ScheduleItemInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.ScheduleItemUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, ScheduleItemDataModel.DataColumns.ScheduleItemId) + ", " + ToSQLParameter(data, ScheduleItemDataModel.DataColumns.ScheduleId) + ", " + ToSQLParameter(data, ScheduleItemDataModel.DataColumns.TotalTimeSpent) + ", " + ToSQLParameter(data, ScheduleItemDataModel.DataColumns.TaskFormulationId); return(sql); }
public override int?Save(string action) { var data = new ScheduleItemDataModel(); data.ScheduleItemId = ScheduleItemId; data.ScheduleId = ScheduleId; data.TaskFormulationId = TaskFormulationId; data.TotalTimeSpent = TotalTimeSpent; if (action == "Insert") { var dtScheduleItem = TaskTimeTracker.Components.Module.TimeTracking.ScheduleItemDataManager.DoesExist(data, SessionVariables.RequestProfile); if (dtScheduleItem.Rows.Count == 0) { TaskTimeTracker.Components.Module.TimeTracking.ScheduleItemDataManager.Create(data, SessionVariables.RequestProfile); } else { throw new Exception("Record with given ID already exists."); } } else { TaskTimeTracker.Components.Module.TimeTracking.ScheduleItemDataManager.Update(data, SessionVariables.RequestProfile); } // not correct ... when doing insert, we didn't get/change the value of ScheduleID ? return(ScheduleItemId); }
public static DataTable Search(ScheduleItemDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 0); var table = list.ToDataTable(); return(table); }
private System.Data.DataTable GetData() { // TODO: on all export pages var data = new ScheduleItemDataModel(); var dt = TaskTimeTracker.Components.Module.TimeTracking.ScheduleItemDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected override DataTable GetEntityData(int?entityKey) { var scheduleItemdata = new ScheduleItemDataModel(); scheduleItemdata.ScheduleItemId = entityKey; var results = ScheduleItemDataManager.Search(scheduleItemdata, SessionVariables.RequestProfile); return(results); }
public static string ToSQLParameter(ScheduleItemDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ScheduleItemDataModel.DataColumns.ScheduleItemId: if (data.ScheduleItemId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleItemDataModel.DataColumns.ScheduleItemId, data.ScheduleItemId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleItemDataModel.DataColumns.ScheduleItemId); } break; case ScheduleItemDataModel.DataColumns.ScheduleId: if (data.ScheduleId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleItemDataModel.DataColumns.ScheduleId, data.ScheduleId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleItemDataModel.DataColumns.ScheduleId); } break; case ScheduleItemDataModel.DataColumns.TaskFormulationId: if (data.TaskFormulationId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleItemDataModel.DataColumns.TaskFormulationId, data.TaskFormulationId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleItemDataModel.DataColumns.TaskFormulationId); } break; case ScheduleItemDataModel.DataColumns.TotalTimeSpent: if (data.TotalTimeSpent != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleItemDataModel.DataColumns.TotalTimeSpent, data.TotalTimeSpent); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleItemDataModel.DataColumns.TotalTimeSpent); } break; default: returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static bool DoesExist(ScheduleItemDataModel data, RequestProfile requestProfile) { var doesExistRequest = new ScheduleItemDataModel(); doesExistRequest.ScheduleId = data.ScheduleId; var list = GetEntityDetails(doesExistRequest, requestProfile, 0); return(list.Count > 0); }
protected override void Clear() { base.Clear(); var data = new ScheduleItemDataModel(); ScheduleItemId = data.ScheduleItemId; ScheduleId = data.ScheduleId; TaskFormulationId = data.TaskFormulationId; TotalTimeSpent = data.TotalTimeSpent; }
public static void Delete(ScheduleItemDataModel dataQuery, RequestProfile requestProfile) { const string sql = @"dbo.ScheduleItemDelete "; var parameters = new { AuditId = requestProfile.AuditId , ScheduleItemId = dataQuery.ScheduleItemId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
protected void btnDelete_Click(object sender, EventArgs e) { try { string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new ScheduleItemDataModel(); data.ScheduleItemId = int.Parse(index); ScheduleItemDataManager.Delete(data, SessionVariables.RequestProfile); } DeleteAndRedirect(); } catch (Exception ex) { Response.Write(ex.Message); } }
protected override DataTable GetData() { try { SuperKey = ApplicationCommon.GetSuperKey(); SetId = ApplicationCommon.GetSetId(); var selectedrows = new DataTable(); var scheduleItemdata = new ScheduleItemDataModel(); selectedrows = TaskTimeTracker.Components.Module.TimeTracking.ScheduleItemDataManager.GetDetails(scheduleItemdata, SessionVariables.RequestProfile).Clone(); if (!string.IsNullOrEmpty(SuperKey)) { var systemEntityTypeId = (int)PrimaryEntity; var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey); foreach (var entityKey in lstEntityKeys) { scheduleItemdata.ScheduleItemId = entityKey; var result = TaskTimeTracker.Components.Module.TimeTracking.ScheduleItemDataManager.GetDetails(scheduleItemdata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } } else { scheduleItemdata.ScheduleItemId = SetId; var result = TaskTimeTracker.Components.Module.TimeTracking.ScheduleItemDataManager.GetDetails(scheduleItemdata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } return(selectedrows); } catch (Exception ex) { Response.Write(ex.Message); } return(null); }
public void LoadData(int scheduleItemId, bool showId) { // clear UI Clear(); var dataQuery = new ScheduleItemDataModel(); dataQuery.ScheduleItemId = scheduleItemId; var items = TaskTimeTracker.Components.Module.TimeTracking.ScheduleItemDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile); if (items.Count != 1) { return; } var item = items[0]; ScheduleItemId = item.ScheduleItemId; ScheduleId = item.ScheduleId; TaskFormulationId = item.TaskFormulationId; TotalTimeSpent = item.TotalTimeSpent; if (!showId) { txtScheduleItemId.Text = item.ScheduleId.ToString(); // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.ScheduleItem, scheduleItemId, "ScheduleItem"); } else { txtScheduleItemId.Text = String.Empty; } oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); }
protected override DataTable UpdateData() { var UpdatedData = new DataTable(); var data = new ScheduleItemDataModel(); UpdatedData = ScheduleItemDataManager.Search(data, SessionVariables.RequestProfile).Clone(); for (var i = 0; i < SelectedData.Rows.Count; i++) { data.ScheduleItemId = Convert.ToInt32(SelectedData.Rows[i][ScheduleItemDataModel.DataColumns.ScheduleItemId].ToString()); data.ScheduleId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(ScheduleItemDataModel.DataColumns.ScheduleId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(ScheduleItemDataModel.DataColumns.ScheduleId).ToString()) : int.Parse(SelectedData.Rows[i][ScheduleItemDataModel.DataColumns.ScheduleId].ToString()); data.TaskFormulationId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(ScheduleItemDataModel.DataColumns.TaskFormulationId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(ScheduleItemDataModel.DataColumns.TaskFormulationId).ToString()) : int.Parse(SelectedData.Rows[i][ScheduleItemDataModel.DataColumns.TaskFormulationId].ToString()); data.TotalTimeSpent = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(ScheduleItemDataModel.DataColumns.TotalTimeSpent)) ? Decimal.Parse(CheckAndGetRepeaterTextBoxValue(ScheduleItemDataModel.DataColumns.TotalTimeSpent).ToString()) : Decimal.Parse(SelectedData.Rows[i][ScheduleItemDataModel.DataColumns.TotalTimeSpent].ToString()); ScheduleItemDataManager.Update(data, SessionVariables.RequestProfile); data = new ScheduleItemDataModel(); data.ScheduleItemId = Convert.ToInt32(SelectedData.Rows[i][ScheduleItemDataModel.DataColumns.ScheduleItemId].ToString()); var dt = TaskTimeTracker.Components.Module.TimeTracking.ScheduleItemDataManager.Search(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 1) { UpdatedData.ImportRow(dt.Rows[0]); } } return(UpdatedData); }
public static ScheduleItemDataModel GetDetails(ScheduleItemDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }
public static void Update(ScheduleItemDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); DBDML.RunSQL("ScheduleItem.Update", sql, DataStoreKey); }