private static string CreateOrUpdate(FunctionalityXFunctionalityActiveStatusDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.FunctionalityXFunctionalityActiveStatusInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; case "Update": sql += "dbo.FunctionalityXFunctionalityActiveStatusUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityXFunctionalityActiveStatusId, data.FunctionalityXFunctionalityActiveStatusId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", " + ToSQLParameter(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityId, data.FunctionalityId) + ", " + ToSQLParameter(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId, data.FunctionalityActiveStatusId) + ", " + ToSQLParameter(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.Memo, data.Memo) + ", " + ToSQLParameter(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.KnowledgeDate, data.KnowledgeDate) + ", " + ToSQLParameter(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.AcknowledgedBy, data.AcknowledgedBy); return(sql); }
protected DataTable GetFunctionalityXFunctionalityActiveStatusData() { var data = new FunctionalityXFunctionalityActiveStatusDataModel(); var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected override void ShowData(int functionalityXFunctionalityActiveStatusid) { oDetailButtonPanel.SetId = SetId; var data = new FunctionalityXFunctionalityActiveStatusDataModel(); data.FunctionalityXFunctionalityActiveStatusId = functionalityXFunctionalityActiveStatusid; var items = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); if (items.Count == 1) { var item = items[0]; lblFunctionalityXFunctionalityActiveStatusId.Text = item.FunctionalityXFunctionalityActiveStatusId.ToString(); lblFunctionalityId.Text = item.Functionality; lblFunctionalityActiveStatusId.Text = item.FunctionalityActiveStatus; lblAcknowledgedBy.Text = item.AcknowledgedBy; lblMemo.Text = item.Memo; lblKnowledgeDate.Text = item.KnowledgeDate.ToString(); oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); oHistoryList.Setup(PrimaryEntity, functionalityXFunctionalityActiveStatusid, "FunctionalityXFunctionalityActiveStatus"); } else { Clear(); } }
public static DataTable Search(FunctionalityXFunctionalityActiveStatusDataModel 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 FunctionalityXFunctionalityActiveStatusDataModel(); var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected override void Update(Dictionary <string, string> values) { var data = new FunctionalityXFunctionalityActiveStatusDataModel(); // copies properties from values dictionary object to data object PropertyMapper.CopyProperties(data, values); TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.Update(data, SessionVariables.RequestProfile); base.Update(values); }
protected override void OnInit(EventArgs e) { try { DynamicUpdatePanel.AddColumns(GetColumns()); SuperKey = ApplicationCommon.GetSuperKey(); SetId = ApplicationCommon.GetSetId(); var key = 0; var functionalityXFunctionalityActiveStatusdata = new FunctionalityXFunctionalityActiveStatusDataModel(); var results = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.Search(functionalityXFunctionalityActiveStatusdata, SessionVariables.RequestProfile).Clone(); if (!string.IsNullOrEmpty(SuperKey)) { var data = new SuperKeyDetailDataModel(); data.SuperKeyId = Convert.ToInt32(SuperKey); // Change System Entity Type data.SystemEntityTypeId = (int)Framework.Components.DataAccess.SystemEntity.FunctionalityXFunctionalityActiveStatus; var dt = Framework.Components.Core.SuperKeyDetailDataManager.Search(data, SessionVariables.RequestProfile); if (dt != null && dt.Rows.Count > 0) { foreach (System.Data.DataRow dr in dt.Rows) { key = Convert.ToInt32(dr[SuperKeyDetailDataModel.DataColumns.EntityKey]); functionalityXFunctionalityActiveStatusdata.FunctionalityXFunctionalityActiveStatusId = key; var functionalityXFunctionalityActiveStatusdt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.Search(functionalityXFunctionalityActiveStatusdata, SessionVariables.RequestProfile); if (functionalityXFunctionalityActiveStatusdt.Rows.Count == 1) { results.ImportRow(functionalityXFunctionalityActiveStatusdt.Rows[0]); } } } } else { key = SetId; functionalityXFunctionalityActiveStatusdata.FunctionalityXFunctionalityActiveStatusId = key; var functionalityXFunctionalityActiveStatusdt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.Search(functionalityXFunctionalityActiveStatusdata, SessionVariables.RequestProfile); if (functionalityXFunctionalityActiveStatusdt.Rows.Count == 1) { results.ImportRow(functionalityXFunctionalityActiveStatusdt.Rows[0]); } } SelectedData = new DataTable(); SelectedData = results.Copy(); base.OnInit(e); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); //throw } }
override protected void btnUpdate_Click(object sender, EventArgs e) { var UpdatedData = new DataTable(); var data = new FunctionalityXFunctionalityActiveStatusDataModel(); UpdatedData = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.Search(data, SessionVariables.RequestProfile).Clone(); for (var i = 0; i < SelectedData.Rows.Count; i++) { data.FunctionalityXFunctionalityActiveStatusId = Convert.ToInt32(SelectedData.Rows[i][FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityXFunctionalityActiveStatusId].ToString()); data.FunctionalityId = Convert.ToInt32(SelectedData.Rows[i][FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityId].ToString()); data.FunctionalityActiveStatusId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId).ToString()) : int.Parse(SelectedData.Rows[i][FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId].ToString()); data.FunctionalityId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityId).ToString()) : int.Parse(SelectedData.Rows[i][FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityId].ToString()); data.Memo = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.Memo)) ? CheckAndGetRepeaterTextBoxValue(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.Memo) : SelectedData.Rows[i][FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.Memo].ToString(); data.AcknowledgedBy = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.AcknowledgedBy)) ? CheckAndGetRepeaterTextBoxValue(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.AcknowledgedBy) : SelectedData.Rows[i][FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.AcknowledgedBy].ToString(); data.KnowledgeDate = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.KnowledgeDate)) ? DateTime.Parse(CheckAndGetRepeaterTextBoxValue(FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.KnowledgeDate).ToString()) : DateTime.Parse(SelectedData.Rows[i][FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.KnowledgeDate].ToString()); TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.Update(data, SessionVariables.RequestProfile); data = new FunctionalityXFunctionalityActiveStatusDataModel(); data.FunctionalityXFunctionalityActiveStatusId = Convert.ToInt32(SelectedData.Rows[i][FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityXFunctionalityActiveStatusId].ToString()); var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.Search(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 1) { UpdatedData.ImportRow(dt.Rows[0]); } } DynamicUpdatePanel.SetUp(GetColumns(), "FunctionalityXFunctionalityActiveStatus", UpdatedData); }
public void LoadData(int functionalityXFunctionalityActiveStatusid, bool showId) { var data = new FunctionalityXFunctionalityActiveStatusDataModel(); data.FunctionalityXFunctionalityActiveStatusId = functionalityXFunctionalityActiveStatusid; var items = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); if (items.Count == 1) { var item = items[0]; if (!showId) { txtFunctionalityXFunctionalityActiveStatusId.Text = item.FunctionalityXFunctionalityActiveStatusId.ToString(); oHistoryList.Setup(PrimaryEntity, functionalityXFunctionalityActiveStatusid, PrimaryEntityKey); } else { txtFunctionalityXFunctionalityActiveStatusId.Text = String.Empty; } txtFunctionalityId.Text = item.FunctionalityId.ToString(); txtFunctionalityActiveStatusId.Text = item.FunctionalityActiveStatusId.ToString(); txtAcknowledgedBy.Text = item.AcknowledgedBy.ToString(); txtMemo.Text = item.Memo.ToString(); txtKnowledgeDate.Text = item.KnowledgeDate.Value.ToString(SessionVariables.UserDateFormat); drpFunctionalityList.SelectedValue = item.FunctionalityId.ToString(); drpFunctionalityActiveStatusList.SelectedValue = item.FunctionalityActiveStatusId.ToString(); oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); } else { txtFunctionalityId.Text = String.Empty; txtFunctionalityActiveStatusId.Text = String.Empty; txtAcknowledgedBy.Text = String.Empty; txtMemo.Text = String.Empty; txtKnowledgeDate.Text = String.Empty; drpFunctionalityList.SelectedValue = "-1"; drpFunctionalityActiveStatusList.SelectedValue = "-1"; } }
public static void Delete(FunctionalityXFunctionalityActiveStatusDataModel dataQuery, RequestProfile requestProfile) { const string sql = @"dbo.FunctionalityXFunctionalityActiveStatusDelete "; var parameters = new { AuditId = requestProfile.AuditId , FunctionalityXFunctionalityActiveStatusId = dataQuery.FunctionalityXFunctionalityActiveStatusId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
protected void btnDelete_Click(object sender, EventArgs e) { try { var notDeletableIds = new List <int>(); string[] deleteIndexList = DeleteIds.Split(','); //foreach (string index in deleteIndexList) //{ // var data = new FunctionalityXFunctionalityActiveStatusDataModel(); // data.FunctionalityXFunctionalityActiveStatusId = int.Parse(index); // if (!TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatus.IsDeletable(data, SessionVariables.RequestProfile.AuditId)) // { // notDeletableIds.Add(Convert.ToInt32(data.FunctionalityXFunctionalityActiveStatusId)); // } //} if (notDeletableIds.Count == 0) { foreach (string index in deleteIndexList) { var data = new FunctionalityXFunctionalityActiveStatusDataModel(); data.FunctionalityXFunctionalityActiveStatusId = int.Parse(index); TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.Delete(data, SessionVariables.RequestProfile); } Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.FunctionalityXFunctionalityActiveStatus, SessionVariables.RequestProfile); Response.Redirect(Page.GetRouteUrl("FunctionalityXFunctionalityActiveStatusEntityRoute", new { Action = "Default", SetId = true }), false); } else { var msg = String.Empty; foreach (var id in notDeletableIds) { if (!string.IsNullOrEmpty(msg)) { msg += ", <br/>"; } msg += "FunctionalityXFunctionalityActiveStatusId: " + id + " has detail records"; } Response.Write(msg); } } catch (Exception ex) { Response.Write(ex.Message); } }
protected override DataTable GetData() { try { SuperKey = ApplicationCommon.GetSuperKey(); SetId = ApplicationCommon.GetSetId(); var selectedrows = new DataTable(); var functionalityXFunctionalityActiveStatusdata = new FunctionalityXFunctionalityActiveStatusDataModel(); selectedrows = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.GetDetails(functionalityXFunctionalityActiveStatusdata, SessionVariables.RequestProfile).Clone(); if (!string.IsNullOrEmpty(SuperKey)) { var systemEntityTypeId = (int)PrimaryEntity; var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey); foreach (var entityKey in lstEntityKeys) { functionalityXFunctionalityActiveStatusdata.FunctionalityXFunctionalityActiveStatusId = entityKey; var result = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.GetDetails(functionalityXFunctionalityActiveStatusdata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } } else { functionalityXFunctionalityActiveStatusdata.FunctionalityXFunctionalityActiveStatusId = SetId; var result = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityActiveStatusDataManager.GetDetails(functionalityXFunctionalityActiveStatusdata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } return(selectedrows); } catch (Exception ex) { Response.Write(ex.Message); } return(null); }
public static void Update(FunctionalityXFunctionalityActiveStatusDataModel data, RequestProfile requestProfile) { var sql = CreateOrUpdate(data, requestProfile, "Update"); DBDML.RunSQL("FunctionalityXFunctionalityActiveStatus.Update", sql, DataStoreKey); }
public static List <FunctionalityXFunctionalityActiveStatusDataModel> GetEntityDetails(FunctionalityXFunctionalityActiveStatusDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.FunctionalityXFunctionalityActiveStatusSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ApplicationMode = requestProfile.ApplicationModeId , FunctionalityXFunctionalityActiveStatusId = dataQuery.FunctionalityXFunctionalityActiveStatusId , FunctionalityId = dataQuery.FunctionalityId , FunctionalityActiveStatusId = dataQuery.FunctionalityActiveStatusId , ReturnAuditInfo = returnAuditInfo }; List <FunctionalityXFunctionalityActiveStatusDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <FunctionalityXFunctionalityActiveStatusDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static FunctionalityXFunctionalityActiveStatusDataModel GetDetails(FunctionalityXFunctionalityActiveStatusDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }
public static string ToSQLParameter(FunctionalityXFunctionalityActiveStatusDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityXFunctionalityActiveStatusId: if (data.FunctionalityXFunctionalityActiveStatusId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityXFunctionalityActiveStatusId, data.FunctionalityXFunctionalityActiveStatusId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityXFunctionalityActiveStatusId); } break; case FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityId: if (data.FunctionalityId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityId, data.FunctionalityId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityId); } break; case FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId: if (data.FunctionalityActiveStatusId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId, data.FunctionalityActiveStatusId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId); } break; case FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.AcknowledgedBy: if (data.AcknowledgedBy != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.AcknowledgedBy, data.AcknowledgedBy); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.AcknowledgedBy); } break; case FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.KnowledgeDate: if (data.KnowledgeDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.KnowledgeDate, data.KnowledgeDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.KnowledgeDate); } break; case FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.Memo: if (data.Memo != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.Memo, data.Memo); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.Memo); } break; case FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.Functionality: if (data.Functionality != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.Functionality, data.Functionality); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.Functionality); } break; case FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatus: if (data.FunctionalityActiveStatus != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatus, data.FunctionalityActiveStatus); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatus); } break; case FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityPriority: if (data.FunctionalityPriority != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatus, data.FunctionalityActiveStatus); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatus); } break; default: returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }