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);
}
protected override DataTable GetEntityData(int?entityKey)
{
var functionalityImagedata = new FunctionalityImageDataModel();
functionalityImagedata.FunctionalityImageId = entityKey;
var results = FunctionalityImageDataManager.Search(functionalityImagedata, SessionVariables.RequestProfile);
return(results);
}
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);
}
private DataTable GetFunctionalityImageData(int functionalityId)
{
var dt = FunctionalityXFunctionalityImageDataManager.GetByFunctionality(functionalityId, SessionVariables.RequestProfile);
var FunctionalityImagedt = FunctionalityImageDataManager.GetList(SessionVariables.RequestProfile);
var resultdt = FunctionalityImagedt.Clone();
foreach (DataRow row in dt.Rows)
{
var rows = FunctionalityImagedt.Select("FunctionalityImageId = " + row[FunctionalityImageDataModel.DataColumns.FunctionalityImageId]);
resultdt.ImportRow(rows[0]);
}
return(resultdt);
}
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);
}
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);
}
private void SetupDropdown()
{
var isTesting = SessionVariables.IsTesting;
var functionalityImageData = FunctionalityImageDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(functionalityImageData, drpFunctionalityImageList,
FunctionalityImageDataModel.DataColumns.Title,
FunctionalityImageDataModel.DataColumns.FunctionalityImageId);
if (isTesting)
{
drpFunctionalityImageList.AutoPostBack = true;
if (drpFunctionalityImageList.Items.Count > 0)
{
if (!string.IsNullOrEmpty(txtFunctionalityImageId.Text.Trim()))
{
drpFunctionalityImageList.SelectedValue = txtFunctionalityImageId.Text;
}
else
{
txtFunctionalityImageId.Text = drpFunctionalityImageList.SelectedItem.Value;
}
}
txtFunctionalityImageId.Visible = true;
}
else
{
if (!string.IsNullOrEmpty(txtFunctionalityImageId.Text.Trim()))
{
drpFunctionalityImageList.SelectedValue = txtFunctionalityImageId.Text;
}
txtFunctionalityImageId.Visible = false;
}
}
public virtual void LoadDropDownListSources(string fieldName, DropDownList dropDownListControl)
{
DataTable dataSource = null;
if (fieldName.Equals("Application"))
{
dataSource = ApplicationDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
BaseDataModel.BaseDataColumns.ApplicationId);
dropDownListControl.SelectedValue = SessionVariables.RequestProfile.ApplicationId.ToString();
}
else if (fieldName.Equals("ParentMenu"))
{
var data = new MenuDataModel();
var appId = BaseSearchFilterControl.GetParameterValueAsInt("Application");
if (appId.HasValue)
{
data.ApplicationId = appId.Value;
}
else
{
data.ApplicationId = SessionVariables.RequestProfile.ApplicationId;
}
dataSource = MenuDataManager.ListOfParentMenuOnly(data, SessionVariables.RequestProfile);
dataSource.DefaultView.Sort = StandardDataModel.StandardDataColumns.Name + " ASC";
dataSource = dataSource.DefaultView.ToTable();
dropDownListControl.Items.Clear();
dropDownListControl.Items.Add(new ListItem("All", "-1"));
dropDownListControl.DataSource = dataSource;
dropDownListControl.DataTextField = StandardDataModel.StandardDataColumns.Name;
dropDownListControl.DataValueField = MenuDataModel.DataColumns.MenuId;
dropDownListControl.DataBind();
}
else if (fieldName.Equals("FunctionalityId"))
{
dataSource = FunctionalityDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
FunctionalityDataModel.DataColumns.FunctionalityId);
}
else if (fieldName.Equals("DeveloperRoleId"))
{
dataSource = DeveloperRoleDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
DeveloperRoleDataModel.DataColumns.DeveloperRoleId);
}
else if (fieldName.Equals("FeatureOwnerStatusId"))
{
dataSource = FeatureOwnerStatusDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
FeatureOwnerStatusDataModel.DataColumns.FeatureOwnerStatusId);
}
else if (fieldName.Equals("EntityId"))
{
dataSource = Framework.Components.Core.SystemEntityTypeDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
DataModel.Framework.Core.SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId);
}
else if (fieldName.Equals("ProjectId"))
{
dataSource = ProjectDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
ProjectDataModel.DataColumns.ProjectId);
}
else if (fieldName.Equals("ApplicationId"))
{
var applicationData = ApplicationDataManager.GetList(SessionVariables.RequestProfile);
var dv = applicationData.DefaultView;
dv.Sort = "Name ASC";
UIHelper.LoadDropDown(dv.ToTable(), dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
BaseDataModel.BaseDataColumns.ApplicationId);
}
else if (fieldName.Equals("FunctionalityOwner"))
{
var drData = FunctionalityOwnerDataManager.GetList(SessionVariables.RequestProfile);
CommonSearchParameters();
var originalList = new ArrayList();
var duplicateList = new ArrayList();
foreach (DataRow dtRow in drData.Rows)
{
if (originalList.Contains(dtRow["Developer"]))
{
duplicateList.Add(dtRow);
}
else
{
originalList.Add(dtRow["Developer"]);
}
}
foreach (DataRow dtRow in duplicateList)
{
drData.Rows.Remove(dtRow);
}
UIHelper.LoadDropDown(drData, dropDownListControl,
FunctionalityOwnerDataModel.DataColumns.Developer,
FunctionalityOwnerDataModel.DataColumns.FunctionalityOwnerId);
}
else if (fieldName.Equals("FunctionalityActiveStatus"))
{
var drData = FunctionalityActiveStatusDataManager.GetList(SessionVariables.RequestProfile);
CommonSearchParameters();
UIHelper.LoadDropDown(drData, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
FunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId);
}
else if (fieldName.Equals("FunctionalityImage"))
{
var drData = FunctionalityImageDataManager.GetList(SessionVariables.RequestProfile);
CommonSearchParameters();
UIHelper.LoadDropDown(drData, dropDownListControl,
FunctionalityImageDataModel.DataColumns.Title,
FunctionalityImageDataModel.DataColumns.FunctionalityImageId);
}
else if (fieldName.Equals("FunctionalityImageAttribute"))
{
var drData = FunctionalityImageAttributeDataManager.GetList(SessionVariables.RequestProfile);
CommonSearchParameters();
UIHelper.LoadDropDown(drData, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImageAttributeId);
}
}
public virtual void LoadDropDownListSources(string fieldName, DropDownList dropDownListControl)
{
DataTable dataSource = null;
if (fieldName.Equals("FunctionalityId"))
{
dataSource = FunctionalityDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
FunctionalityDataModel.DataColumns.FunctionalityId);
}
else if (fieldName.Equals("ProjectId"))
{
dataSource = ProjectDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
ProjectDataModel.DataColumns.ProjectId);
}
else if (fieldName.Equals("DeveloperRoleId"))
{
dataSource = DeveloperRoleDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
DeveloperRoleDataModel.DataColumns.DeveloperRoleId);
}
else if (fieldName.Equals("UseCaseId"))
{
dataSource = UseCaseDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
UseCaseDataModel.DataColumns.UseCaseId);
}
else if (fieldName.Equals("NeedId"))
{
dataSource = NeedDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
NeedDataModel.DataColumns.NeedId);
}
else if (fieldName.Equals("ProjectUseCaseStatusId"))
{
dataSource = ProjectUseCaseStatusDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
ProjectUseCaseStatusDataModel.DataColumns.ProjectUseCaseStatusId);
}
else if (fieldName.Equals("FeatureOwnerStatusId"))
{
dataSource = FeatureOwnerStatusDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
FeatureOwnerStatusDataModel.DataColumns.FeatureOwnerStatusId);
}
else if (fieldName.Equals("EntityId"))
{
dataSource = Framework.Components.Core.SystemEntityTypeDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
DataModel.Framework.Core.SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId);
}
else if (fieldName.Equals("ProjectId"))
{
dataSource = ProjectDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
ProjectDataModel.DataColumns.ProjectId);
}
else if (fieldName.Equals("ApplicationId"))
{
var applicationData = ApplicationDataManager.GetList(SessionVariables.RequestProfile);
var dv = applicationData.DefaultView;
dv.Sort = "Name ASC";
UIHelper.LoadDropDown(dv.ToTable(), dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
BaseDataModel.BaseDataColumns.ApplicationId);
}
else if (fieldName.Equals("FunctionalityOwner"))
{
var drData = FunctionalityOwnerDataManager.GetList(SessionVariables.RequestProfile);
CommonSearchParameters();
var originalList = new ArrayList();
var duplicateList = new ArrayList();
foreach (DataRow dtRow in drData.Rows)
{
if (originalList.Contains(dtRow["Developer"]))
{
duplicateList.Add(dtRow);
}
else
{
originalList.Add(dtRow["Developer"]);
}
}
foreach (DataRow dtRow in duplicateList)
{
drData.Rows.Remove(dtRow);
}
UIHelper.LoadDropDown(drData, dropDownListControl,
FunctionalityOwnerDataModel.DataColumns.Developer,
FunctionalityOwnerDataModel.DataColumns.FunctionalityOwnerId);
}
else if (fieldName.Equals("FunctionalityActiveStatus"))
{
var drData = FunctionalityActiveStatusDataManager.GetList(SessionVariables.RequestProfile);
CommonSearchParameters();
UIHelper.LoadDropDown(drData, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
FunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId);
}
else if (fieldName.Equals("FunctionalityImage"))
{
var drData = FunctionalityImageDataManager.GetList(SessionVariables.RequestProfile);
CommonSearchParameters();
UIHelper.LoadDropDown(drData, dropDownListControl,
FunctionalityImageDataModel.DataColumns.Title,
FunctionalityImageDataModel.DataColumns.FunctionalityImageId);
}
else if (fieldName.Equals("FunctionalityImageAttribute"))
{
var drData = FunctionalityImageAttributeDataManager.GetList(SessionVariables.RequestProfile);
CommonSearchParameters();
UIHelper.LoadDropDown(drData, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImageAttributeId);
}
else if (fieldName.Equals("TabParentStructure"))
{
var drData = TabParentStructureDataManager.GetList(SessionVariables.RequestProfile);
CommonSearchParameters();
UIHelper.LoadDropDown(drData, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
TabParentStructureDataModel.DataColumns.TabParentStructureId);
}
}
private void SetupDropdown()
{
var isTesting = SessionVariables.IsTesting;
var functionalityImageData = FunctionalityImageDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(functionalityImageData, drpFunctionalityImageList,
FunctionalityImageDataModel.DataColumns.Title,
FunctionalityImageDataModel.DataColumns.FunctionalityImageId);
var functionalityImageAttributeData = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityImageAttributeDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(functionalityImageAttributeData, drpFunctionalityImageAttributeList,
StandardDataModel.StandardDataColumns.Name,
FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImageAttributeId);
if (isTesting)
{
drpFunctionalityImageList.AutoPostBack = true;
drpFunctionalityImageAttributeList.AutoPostBack = true;
if (drpFunctionalityImageList.Items.Count > 0)
{
if (!string.IsNullOrEmpty(txtFunctionalityImageId.Text.Trim()))
{
drpFunctionalityImageList.SelectedValue = txtFunctionalityImageId.Text;
}
else
{
txtFunctionalityImageId.Text = drpFunctionalityImageList.SelectedItem.Value;
}
}
if (drpFunctionalityImageAttributeList.Items.Count > 0)
{
if (!string.IsNullOrEmpty(txtFunctionalityImageAttributeId.Text.Trim()))
{
drpFunctionalityImageAttributeList.SelectedValue = txtFunctionalityImageAttributeId.Text;
}
else
{
txtFunctionalityImageAttributeId.Text = drpFunctionalityImageAttributeList.SelectedItem.Value;
}
}
txtFunctionalityImageId.Visible = true;
txtFunctionalityImageAttributeId.Visible = true;
}
else
{
if (!string.IsNullOrEmpty(txtFunctionalityImageId.Text.Trim()))
{
drpFunctionalityImageList.SelectedValue = txtFunctionalityImageId.Text;
}
if (!string.IsNullOrEmpty(txtFunctionalityImageAttributeId.Text.Trim()))
{
drpFunctionalityImageAttributeList.SelectedValue = txtFunctionalityImageAttributeId.Text;
}
txtFunctionalityImageId.Visible = false;
txtFunctionalityImageAttributeId.Visible = false;
}
}
protected override DataTable GetData()
{
var dt = FunctionalityImageDataManager.Search(oSearchFilter.SearchParameters, SessionVariables.RequestProfile);
return(dt);
}