public static List <FunctionalityImageInstanceDataModel> GetEntityDetails(FunctionalityImageInstanceDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.FunctionalityImageInstanceSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ApplicationMode = requestProfile.ApplicationModeId , FunctionalityImageInstanceId = dataQuery.FunctionalityImageInstanceId , FunctionalityImageId = dataQuery.FunctionalityImageId , FunctionalityImageAttributeId = dataQuery.FunctionalityImageAttributeId , ReturnAuditInfo = returnAuditInfo }; List <FunctionalityImageInstanceDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <FunctionalityImageInstanceDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public override int?Save(string action) { var data = new FunctionalityImageInstanceDataModel(); data.FunctionalityImageInstanceId = FunctionalityImageInstanceId; data.FunctionalityImageId = FunctionalityImageId; data.FunctionalityImageAttributeId = FunctionalityImageAttributeId; if (action == "Insert") { //var dtApplicationMode = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityImageInstanceDataManager.DoesExist(data, AuditId); //if (dtApplicationMode.Rows.Count == 0) //{ TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityImageInstanceDataManager.Create(data, SessionVariables.RequestProfile); //} //else //{ // throw new Exception("Record with given ID already exists."); //} } else { TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityImageInstanceDataManager.Update(data, SessionVariables.RequestProfile); } // not correct ... when doing insert, we didn't get/change the value of ClientID ? return(data.FunctionalityImageInstanceId); }
private static string CreateOrUpdate(FunctionalityImageInstanceDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.FunctionalityImageInstanceInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.FunctionalityImageInstanceUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageInstanceId) + ", " + ToSQLParameter(data, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageId) + ", " + ToSQLParameter(data, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageAttributeId); return(sql); }
public static DataTable Search(FunctionalityImageInstanceDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 0); var table = list.ToDataTable(); return(table); }
private DataTable GetData(string name) { var data = new FunctionalityImageInstanceDataModel(); var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityImageInstanceDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
private System.Data.DataTable GetData() { // TODO: on all export pages var data = new FunctionalityImageInstanceDataModel(); var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityImageInstanceDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected override void Clear() { base.Clear(); var data = new FunctionalityImageInstanceDataModel(); FunctionalityImageInstanceId = data.FunctionalityImageInstanceId; FunctionalityImageAttributeId = data.FunctionalityImageAttributeId; FunctionalityImageId = data.FunctionalityImageId; }
private static DataSet GetChildren(FunctionalityImageInstanceDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.FunctionalityImageInstanceChildrenGet " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageInstanceId); var oDT = new DBDataSet("Get Children", sql, DataStoreKey); return(oDT.DBDataset); }
public static bool DoesExist(FunctionalityImageInstanceDataModel data, RequestProfile requestProfile) { var doesExistRequest = new FunctionalityImageInstanceDataModel(); doesExistRequest.Name = data.Name; var list = GetEntityDetails(doesExistRequest, requestProfile, 0); return(list.Count > 0); }
public static void Delete(FunctionalityImageInstanceDataModel dataQuery, RequestProfile requestProfile) { const string sql = @"dbo.FunctionalityImageInstanceDelete "; var parameters = new { AuditId = requestProfile.AuditId , FunctionalityImageInstanceId = dataQuery.FunctionalityImageInstanceId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
public static bool IsDeletable(FunctionalityImageInstanceDataModel data, RequestProfile requestProfile) { var isDeletable = true; var ds = GetChildren(data, requestProfile); if (ds != null && ds.Tables.Count > 0) { foreach (DataTable dt in ds.Tables) { if (dt.Rows.Count > 0) { isDeletable = false; break; } } } return(isDeletable); }
protected void btnDelete_Click(object sender, EventArgs e) { try { string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new FunctionalityImageInstanceDataModel(); data.FunctionalityImageInstanceId = int.Parse(index); TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityImageInstanceDataManager.Delete(data, SessionVariables.RequestProfile); } DeleteAndRedirect(); } catch (Exception ex) { Response.Write(ex.Message); } }
public void LoadData(int FunctionalityImageInstanceId, bool showId) { // clear UI Clear(); // set up parameters var data = new FunctionalityImageInstanceDataModel(); data.FunctionalityImageInstanceId = FunctionalityImageInstanceId; // get data var items = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityImageInstanceDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); // should only have single match -- should log exception. if (items.Count != 1) { return; } var item = items[0]; txtFunctionalityImageInstanceId.Text = item.FunctionalityImageInstanceId.ToString(); txtFunctionalityImageAttributeId.Text = item.FunctionalityImageAttributeId.ToString(); txtFunctionalityImageId.Text = item.FunctionalityImageId.ToString(); imgApplicationUserImage.Visible = true; imgApplicationUserImage.ImageUrl = "~/ApplicationDevelopment/FunctionalityImage/ShowImage.aspx?imageid=" + item.FunctionalityImageId; imgApplicationUserImage1.ImageUrl = "~/ApplicationDevelopment/FunctionalityImage/ShowImage.aspx?imageid=" + item.FunctionalityImageId; if (!showId) { txtFunctionalityImageInstanceId.Text = item.FunctionalityImageInstanceId.ToString(); //PlaceHolderAuditHistory.Visible = true; // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup(PrimaryEntity, FunctionalityImageInstanceId, PrimaryEntityKey); } else { txtFunctionalityImageInstanceId.Text = String.Empty; } oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); }
protected override void ShowData(int FunctionalityImageInstanceId) { base.ShowData(FunctionalityImageInstanceId); oDetailButtonPanel.SetId = SetId; Clear(); var data = new FunctionalityImageInstanceDataModel(); data.FunctionalityImageInstanceId = FunctionalityImageInstanceId; var items = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityImageInstanceDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); int functionalityImageId = 0; if (items.Count == 1) { var item = items[0]; functionalityImageId = (int)item.FunctionalityImageId; lblFunctionalityImageInstanceId.Text = item.FunctionalityImageInstanceId.ToString(); lblFunctionalityImageId.Text = item.FunctionalityImageId.ToString(); lblFunctionalityImageAttributeId.Text = item.FunctionalityImageAttributeId.ToString(); imgApplicationUserImage.Visible = true; imgApplicationUserImage.ImageUrl = "~/ApplicationDevelopment/FunctionalityImage/ShowImage.aspx?imageid=" + functionalityImageId.ToString(); imgApplicationUserImage1.ImageUrl = "~/ApplicationDevelopment/FunctionalityImage/ShowImage.aspx?imageid=" + functionalityImageId.ToString(); oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); oHistoryList.Setup(PrimaryEntity, FunctionalityImageInstanceId, "FunctionalityImageInstance"); } else { Clear(); } }
public static FunctionalityImageInstanceDataModel GetDetails(FunctionalityImageInstanceDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile); return(list.FirstOrDefault()); }
public static void Update(FunctionalityImageInstanceDataModel data, RequestProfile requestProfile) { var sql = CreateOrUpdate(data, requestProfile, "Update"); DBDML.RunSQL("FunctionalityImageInstance.Update", sql, DataStoreKey); }
public static string ToSQLParameter(FunctionalityImageInstanceDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageInstanceId: if (data.FunctionalityImageInstanceId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageInstanceId, data.FunctionalityImageInstanceId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageInstanceId); } break; case FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageId: if (data.FunctionalityImageId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageId, data.FunctionalityImageId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageId); } break; case FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageAttributeId: if (data.FunctionalityImageAttributeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageAttributeId, data.FunctionalityImageAttributeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageAttributeId); } break; case FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImage: if (!string.IsNullOrEmpty(data.FunctionalityImage)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImage, data.FunctionalityImage.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImage); } break; case FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageAttribute: if (!string.IsNullOrEmpty(data.FunctionalityImageAttribute)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageAttribute, data.FunctionalityImageAttribute.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageAttribute); } break; } return(returnValue); }