private System.Data.DataTable GetData() { // TODO: on all export pages var data = new DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel(); var dt = SkillXPersonXSkillLevelDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected override DataTable GetEntityData(int?entityKey) { var skillXPersonXSkillLeveldata = new DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel(); skillXPersonXSkillLeveldata.SkillXPersonXSkillLevelId = entityKey; var results = SkillXPersonXSkillLevelDataManager.Search(skillXPersonXSkillLeveldata, SessionVariables.RequestProfile); return(results); }
protected override void Update(Dictionary <string, string> values) { var data = new DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel(); data.SkillXPersonXSkillLevelId = int.Parse(values[DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.SkillXPersonXSkillLevelId].ToString()); data.SkillId = int.Parse(values[DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.SkillId].ToString()); data.PersonId = int.Parse(values[DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.PersonId].ToString()); data.SkillLevelId = int.Parse(values[DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevelId].ToString()); SkillXPersonXSkillLevelDataManager.Update(data, SessionVariables.RequestProfile); InlineEditingList.Data = GetData(); }
protected void btnDelete_Click(object sender, EventArgs e) { try { string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel(); data.SkillXPersonXSkillLevelId = int.Parse(index); SkillXPersonXSkillLevelDataManager.Delete(data, SessionVariables.RequestProfile); } DeleteAndRedirect(); } catch (Exception ex) { Response.Write(ex.Message); } }
protected override DataTable UpdateData() { var UpdatedData = new DataTable(); var data = new DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel(); UpdatedData = SkillXPersonXSkillLevelDataManager.Search(data, SessionVariables.RequestProfile).Clone(); for (var i = 0; i < SelectedData.Rows.Count; i++) { data.SkillXPersonXSkillLevelId = Convert.ToInt32(SelectedData.Rows[i][DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.SkillXPersonXSkillLevelId].ToString()); data.SkillId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.SkillId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.SkillId).ToString()) : int.Parse(SelectedData.Rows[i][DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.SkillId].ToString()); data.SkillLevelId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevelId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevelId).ToString()) : int.Parse(SelectedData.Rows[i][DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevelId].ToString()); data.PersonId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.PersonId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.PersonId).ToString()) : int.Parse(SelectedData.Rows[i][DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.PersonId].ToString()); SkillXPersonXSkillLevelDataManager.Update(data, SessionVariables.RequestProfile); data = new DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel(); data.SkillXPersonXSkillLevelId = Convert.ToInt32(SelectedData.Rows[i][DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel.DataColumns.SkillXPersonXSkillLevelId].ToString()); var dt = SkillXPersonXSkillLevelDataManager.Search(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 1) { UpdatedData.ImportRow(dt.Rows[0]); } } return(UpdatedData); }
protected override DataTable GetData() { try { var superKey = ApplicationCommon.GetSuperKey(); var setId = ApplicationCommon.GetSetId(); var selectedrows = new DataTable(); var skillXPersonXSkillLeveldata = new DataModel.TaskTimeTracker.Competency.SkillXPersonXSkillLevelDataModel(); selectedrows = SkillXPersonXSkillLevelDataManager.GetDetails(skillXPersonXSkillLeveldata, SessionVariables.RequestProfile).Clone(); if (!string.IsNullOrEmpty(SuperKey)) { var systemEntityTypeId = (int)PrimaryEntity; var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey); foreach (var entityKey in lstEntityKeys) { skillXPersonXSkillLeveldata.SkillLevelId = entityKey; var result = SkillXPersonXSkillLevelDataManager.GetDetails(skillXPersonXSkillLeveldata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } } else { skillXPersonXSkillLeveldata.SkillLevelId = SetId; var result = SkillXPersonXSkillLevelDataManager.GetDetails(skillXPersonXSkillLeveldata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } return(selectedrows); } catch (Exception ex) { Response.Write(ex.Message); } return(null); }