protected override DataTable UpdateData() { var UpdatedData = new DataTable(); var data = new FunctionalityImageDataModel(); UpdatedData = FunctionalityImageDataManager.Search(data, SessionVariables.RequestProfile).Clone(); for (var i = 0; i < SelectedData.Rows.Count; i++) { data.FunctionalityImageId = Convert.ToInt32(SelectedData.Rows[i][FunctionalityImageDataModel.DataColumns.FunctionalityImageId].ToString()); data.Title = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityImageDataModel.DataColumns.Title)) ? CheckAndGetRepeaterTextBoxValue(FunctionalityImageDataModel.DataColumns.Title) : SelectedData.Rows[i][FunctionalityImageDataModel.DataColumns.Title].ToString(); data.ApplicationId = Convert.ToInt32(SelectedData.Rows[i][BaseDataModel.BaseDataColumns.ApplicationId].ToString()); data.Image = Encoding.ASCII.GetBytes(SelectedData.Rows[i][FunctionalityImageDataModel.DataColumns.Image].ToString()); FunctionalityImageDataManager.Update(data, SessionVariables.RequestProfile); data = new FunctionalityImageDataModel(); data.FunctionalityImageId = Convert.ToInt32(SelectedData.Rows[i][FunctionalityImageDataModel.DataColumns.FunctionalityImageId].ToString()); var dt = FunctionalityImageDataManager.Search(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 1) { UpdatedData.ImportRow(dt.Rows[0]); } } return(UpdatedData); }
protected override void ShowData(int functionalityImageId) { base.ShowData(functionalityImageId); oDetailButtonPanel.SetId = SetId; Clear(); var dataQuery = new FunctionalityImageDataModel(); dataQuery.FunctionalityImageId = functionalityImageId; var entityList = FunctionalityImageDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile); if (entityList.Count == 1) { foreach (var entityItem in entityList) { lblFunctionalityImageId.Text = entityItem.FunctionalityImageId.ToString(); lblTitle.Text = entityItem.Title.ToString(); lblApplication.Text = entityItem.Application.ToString(); imgApplicationUserImage.ImageUrl = "~/ApplicationDevelopment/FunctionalityImage/ShowImage.aspx?imageid=" + entityItem.FunctionalityImageId.ToString(); oUpdateInfo.LoadText(entityItem.UpdatedDate, entityItem.UpdatedBy, entityItem.LastAction); oHistoryList.Setup(PrimaryEntity, functionalityImageId, "FunctionalityImage"); } } }
private DataTable GetData() { var data = new FunctionalityImageDataModel(); var dt = FunctionalityImageDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
public override int?Save(string action) { var data = new FunctionalityImageDataModel(); data.FunctionalityImageId = FunctionalityImageId; data.ApplicationId = ApplicationId; data.Image = Image; data.Title = Title; data.Description = Description; if (action == "Insert") { var dt = FunctionalityImageDataManager.DoesExist(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 0) { FunctionalityImageDataManager.Create(data, SessionVariables.RequestProfile); } else { throw new Exception("Record with given ID already exists."); } } else { FunctionalityImageDataManager.Update(data, SessionVariables.RequestProfile); } // not correct ... when doing insert, we didn't get/change the value of ClientID ? return(data.FunctionalityImageId); }
//public static string ToSQLParameter(FunctionalityImageDataModel data, string dataColumnName) //{ // var returnValue = "NULL"; // switch (dataColumnName) // { // case FunctionalityImageDataModel.DataColumns.FunctionalityImageId: // if (data.FunctionalityImageId != null) // { // returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityImageDataModel.DataColumns.FunctionalityImageId, data.FunctionalityImageId); // } // else // { // returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityImageDataModel.DataColumns.FunctionalityImageId); // } // break; // case FunctionalityImageDataModel.DataColumns.Title: // if (!string.IsNullOrEmpty(data.Title)) // { // returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityImageDataModel.DataColumns.Title, data.Title); // } // else // { // returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityImageDataModel.DataColumns.Title); // } // break; // case FunctionalityImageDataModel.DataColumns.Description: // if (!string.IsNullOrEmpty(data.Description)) // { // returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityImageDataModel.DataColumns.Description, data.Description); // } // else // { // returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityImageDataModel.DataColumns.Description); // } // break; // case FunctionalityImageDataModel.DataColumns.Image: // if (data.Image != null) // { // returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityImageDataModel.DataColumns.Image,data.Image); // } // else // { // returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityImageDataModel.DataColumns.Image); // } // break; // case FunctionalityImageDataModel.DataColumns.Application: // if (!string.IsNullOrEmpty(data.Application)) // { // returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityImageDataModel.DataColumns.Application, data.Application); // } // else // { // returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityImageDataModel.DataColumns.Application); // } // break; // } // return returnValue; //} public static DataTable Search(FunctionalityImageDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 0); var table = list.ToDataTable(); return(table); }
protected override DataTable GetEntityData(int?entityKey) { var functionalityImagedata = new FunctionalityImageDataModel(); functionalityImagedata.FunctionalityImageId = entityKey; var results = FunctionalityImageDataManager.Search(functionalityImagedata, SessionVariables.RequestProfile); return(results); }
//private static string CreateOrUpdate(FunctionalityImageDataModel data, RequestProfile requestProfile, string action) //{ // //var sql = "EXEC "; // //switch (action) // //{ // // case "Create": // // sql += "dbo.FunctionalityImageInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", "; // // break; // // case "Update": // // sql += "dbo.FunctionalityImageUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", "; ; // // break; // // default: // // break; // //} // //sql = sql + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + // // ", " + ToSQLParameter(data, FunctionalityImageDataModel.DataColumns.FunctionalityImageId) + // // ", " + ToSQLParameter(data, FunctionalityImageDataModel.DataColumns.Title) + // // ", @Image="+(new SqlParameter(FunctionalityImageDataModel.DataColumns.Image, data.Image)) + // // ", " + ToSQLParameter(data, FunctionalityImageDataModel.DataColumns.Description); // return string.Empty; //} #endregion #region DoesExist public static bool DoesExist(FunctionalityImageDataModel data, RequestProfile requestProfile) { var doesExistRequest = new FunctionalityImageDataModel(); doesExistRequest.Title = data.Title; var list = GetEntityDetails(doesExistRequest, requestProfile, 0); return(list.Count > 0); }
protected override void Update(Dictionary <string, string> values) { var data = new FunctionalityImageDataModel(); // copies properties from values dictionary object to data object PropertyMapper.CopyProperties(data, values); FunctionalityImageDataManager.Update(data, SessionVariables.RequestProfile); base.Update(values); }
protected override void Clear() { base.Clear(); var data = new FunctionalityImageDataModel(); FunctionalityImageId = data.FunctionalityImageId; Image = data.Image; Title = data.Title; }
public static List <StandardListDataModel> GetFunctionalityImageList(RequestProfile requestProfile) { var data = new FunctionalityImageDataModel(); var list = GetEntityDetails(data, requestProfile); var result = list.Select(item => new StandardListDataModel() { Name = item.Title, Value = item.FunctionalityImageId.ToString() }) .ToList(); return(result); }
public static void Delete(FunctionalityImageDataModel dataQuery, RequestProfile requestProfile) { const string sql = @"dbo.FunctionalityImageDelete "; var parameters = new { AuditId = requestProfile.AuditId , FunctionalityImageId = dataQuery.FunctionalityImageId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
public void LoadData(int functionalityImageId, bool showId) { // clear UI Clear(); // set up parameters var data = new FunctionalityImageDataModel(); data.FunctionalityImageId = functionalityImageId; // get data var items = FunctionalityImageDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); // should only have single match -- should log exception. if (items.Count != 1) { return; } var item = items[0]; largeImage = "/MA/ApplicationDevelopment/FunctionalityImage/ShowImage.aspx?imageid=" + Convert.ToString(item.FunctionalityImageId); smallImage = "/MA/ApplicationDevelopment/FunctionalityImage/ShowImage.aspx?imageid=" + Convert.ToString(item.FunctionalityImageId); imgApplicationUserImage.ImageUrl = "~/MA/ApplicationDevelopment/FunctionalityImage/ShowImage.aspx?imageid=" + Convert.ToString(item.FunctionalityImageId); imgApplicationUserImage1.ImageUrl = "~/MA/ApplicationDevelopment/FunctionalityImage/ShowImage.aspx?imageid=" + Convert.ToString(item.FunctionalityImageId); //hrfApplicationUserImage.HRef = "~/ApplicationDevelopment/FunctionalityImage/ShowImage.aspx?imageid=" + Convert.ToString(row[TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityImage.DataColumns.FunctionalityImageId]); txtTitle.Text = Convert.ToString(item.Title); txtApplication.Text = Convert.ToString(item.ApplicationId); drpApplication.Text = Convert.ToString(item.ApplicationId); txtDescription.Text = item.Description; if (!showId) { txtFunctionalityImageId.Text = item.FunctionalityImageId.ToString(); //PlaceHolderAuditHistory.Visible = true; // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup(PrimaryEntity, functionalityImageId, PrimaryEntityKey); } else { txtFunctionalityImageId.Text = String.Empty; } oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); }
public static void Create(FunctionalityImageDataModel data, RequestProfile requestProfile) { //var sql = CreateOrUpdate(data, requestProfile, "Create"); //DBDML.RunSQL("FunctionalityHistory.Insert", sql, DataStoreKey); var sql = "FunctionalityImageInsert"; var parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId)); parameters.Add(new SqlParameter(BaseDataModel.BaseDataColumns.ApplicationId, data.ApplicationId)); parameters.Add(new SqlParameter(FunctionalityImageDataModel.DataColumns.Title, data.Title)); parameters.Add(new SqlParameter(FunctionalityImageDataModel.DataColumns.Image, data.Image)); parameters.Add(new SqlParameter(FunctionalityImageDataModel.DataColumns.Description, data.Description)); DBDML.RunSQLWithParameters("FunctionalityImage.Insert", sql, parameters.ToArray(), DataStoreKey); }
protected void Page_Load(object sender, EventArgs e) { int imageId = Convert.ToInt32(Request.QueryString["imageid"]); var data = new FunctionalityImageDataModel(); data.FunctionalityImageId = imageId; var dt = FunctionalityImageDataManager.GetDetails(data, SessionVariables.RequestProfile); if (dt.Rows.Count > 0) { var imageData = ((byte[])(dt.Rows[0][FunctionalityImageDataModel.DataColumns.Image])); Response.Clear(); Response.ContentType = "image/pjpeg"; Response.BinaryWrite(imageData); Response.End(); } }
protected void btnDelete_Click(object sender, EventArgs e) { try { string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new FunctionalityImageDataModel(); data.FunctionalityImageId = int.Parse(index); FunctionalityImageDataManager.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 functionalityImagedata = new FunctionalityImageDataModel(); selectedrows = FunctionalityImageDataManager.GetDetails(functionalityImagedata, SessionVariables.RequestProfile).Clone(); if (!string.IsNullOrEmpty(SuperKey)) { var systemEntityTypeId = (int)PrimaryEntity; var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey); foreach (var entityKey in lstEntityKeys) { functionalityImagedata.FunctionalityImageId = entityKey; var result = FunctionalityImageDataManager.GetDetails(functionalityImagedata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } } else if (SetId != 0) { var key = SetId; functionalityImagedata.FunctionalityImageId = key; var result = FunctionalityImageDataManager.GetDetails(functionalityImagedata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } return(selectedrows); } catch (Exception ex) { Response.Write(ex.Message); } return(null); }
public static List <FunctionalityImageDataModel> GetEntityDetails(FunctionalityImageDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.FunctionalityImageSearch "; var parameters = new { AuditId = requestProfile.AuditId , FunctionalityImageId = dataQuery.FunctionalityImageId , Title = dataQuery.Title , ApplicationMode = requestProfile.ApplicationModeId , ReturnAuditInfo = returnAuditInfo }; List <FunctionalityImageDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <FunctionalityImageDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static FunctionalityImageDataModel GetDetails(FunctionalityImageDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile); return(list.FirstOrDefault()); }