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());
}
