public override int?Save(string action)
{
var data = new FunctionalityDataModel();
data.FunctionalityId = SystemKeyId;
data.Name = Name;
data.Description = Description;
data.SortOrder = SortOrder;
data.FunctionalityActiveStatusId = FunctionalityActiveStatusId;
data.FunctionalityPriorityId = FunctionalityPriorityId;
if (action == "Insert")
{
var dtFunctionality = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.DoesExist(data, SessionVariables.RequestProfile);
if (dtFunctionality.Rows.Count == 0)
{
TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Create(data, SessionVariables.RequestProfile);
}
else
{
throw new Exception("Record with given ID already exists.");
}
}
else
{
TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Update(data, SessionVariables.RequestProfile);
}
return(data.FunctionalityId);
}
protected override void ShowData(int functionalityId)
{
oDetailButtonPanel.SetId = SetId;
var data = new FunctionalityDataModel();
data.FunctionalityId = functionalityId;
var items = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.GetEntityDetails(data, SessionVariables.RequestProfile);
if (items.Count == 1)
{
var item = items[0];
lblFunctionalityId.Text = item.FunctionalityId.ToString();
lblApplicationId.Text = SessionVariables.RequestProfile.ApplicationId.ToString();
lblName.Text = item.Name;
lblDescription.Text = item.Description;
lblSortOrder.Text = item.SortOrder.ToString();
lblFunctionalityActiveStatusId.Text = item.FunctionalityActiveStatus.ToString();
lblFunctionalityPriorityId.Text = item.FunctionalityPriority.ToString();
oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction);
oHistoryList.Setup(PrimaryEntity, functionalityId, "Functionality");
}
else
{
Clear();
}
}
public static List <FunctionalityDataModel> GetEntityDetails(FunctionalityDataModel dataQuery, RequestProfile requestedProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.FunctionalitySearch ";
var parameters =
new
{
AuditId = requestedProfile.AuditId
, ApplicationId = dataQuery.ApplicationId
, FunctionalityId = dataQuery.FunctionalityId
, Name = dataQuery.Name
, FunctionalityPriorityId = dataQuery.FunctionalityPriorityId
, FunctionalityActiveStatusId = dataQuery.FunctionalityActiveStatus
, NumberOfImages = dataQuery.NumberOfImages
, ReturnAuditInfo = returnAuditInfo
};
List <FunctionalityDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <FunctionalityDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
private static string CreateOrUpdate(FunctionalityDataModel data, RequestProfile requestedProfile, string action)
{
var sql = "EXEC ";
switch (action)
{
case "Create":
sql += "dbo.FunctionalityInsert " + "\r\n" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestedProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestedProfile.ApplicationId);
break;
case "Update":
sql += "dbo.FunctionalityUpdate " + "\r\n" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestedProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestedProfile.ApplicationId);
break;
default:
break;
}
sql = sql + ", " + ToSQLParameter(data, FunctionalityDataModel.DataColumns.FunctionalityId) +
", " + ToSQLParameter(data, FunctionalityDataModel.StandardDataColumns.Name) +
", " + ToSQLParameter(data, FunctionalityDataModel.StandardDataColumns.Description) +
", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.SortOrder) +
", " + ToSQLParameter(data, FunctionalityDataModel.DataColumns.FunctionalityActiveStatusId) +
", " + ToSQLParameter(data, FunctionalityDataModel.DataColumns.FunctionalityPriorityId);
return(sql);
}
public static List <FunctionalityDataModel> GetFunctionalityList(RequestProfile requestedProfile)
{
var sql = "EXEC dbo.FunctionalitySearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestedProfile.AuditId); // +
//", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestedProfile.ApplicationId);
var result = new List <FunctionalityDataModel>();
using (var reader = new DBDataReader("Get List", sql, DataStoreKey))
{
var dbReader = reader.DBReader;
while (dbReader.Read())
{
var dataItem = new FunctionalityDataModel();
dataItem.ApplicationId = (int)dbReader[FunctionalityDataModel.DataColumns.ApplicationId];
dataItem.FunctionalityId = (int)dbReader[FunctionalityDataModel.DataColumns.FunctionalityId];
dataItem.FunctionalityPriorityId = (int)dbReader[FunctionalityDataModel.DataColumns.FunctionalityPriorityId];
dataItem.FunctionalityActiveStatusId = (int)dbReader[FunctionalityDataModel.DataColumns.FunctionalityActiveStatusId];
dataItem.Description = dbReader[StandardDataModel.StandardDataColumns.Description].ToString();
dataItem.SortOrder = (int)dbReader[StandardDataModel.StandardDataColumns.SortOrder];
dataItem.Name = dbReader[StandardDataModel.StandardDataColumns.Name].ToString();
result.Add(dataItem);
}
}
return(result);
}
public void SetData(FunctionalityDataModel data)
{
SystemKeyId = data.FunctionalityId;
FunctionalityPriorityId = data.FunctionalityPriorityId;
base.SetData(data);
}
protected override void Clear()
{
base.Clear();
var data = new FunctionalityDataModel();
SetData(data);
}
public static DataTable Search(FunctionalityDataModel data, RequestProfile requestedProfile)
{
var list = GetEntityDetails(data, requestedProfile, 0);
var table = list.ToDataTable();
return(table);
}
protected override DataTable GetEntityData(int?entityKey)
{
var functionalitydata = new FunctionalityDataModel();
functionalitydata.FunctionalityId = entityKey;
var results = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Search(functionalitydata, SessionVariables.RequestProfile);
return(results);
}
private System.Data.DataTable GetData()
{
// TODO: on all export pages
var data = new FunctionalityDataModel();
var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
private DataTable GetData(string name)
{
var data = new FunctionalityDataModel();
data.Name = name;
var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
public static bool DoesExist(FunctionalityDataModel data, RequestProfile requestProfile)
{
var doesExistRequest = new FunctionalityDataModel();
doesExistRequest.Name = data.Name;
var list = GetEntityDetails(doesExistRequest, requestProfile, 0);
return(list.Count > 0);
}
public static DataSet DeleteChildren(FunctionalityDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FunctionalityChildrenDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, FunctionalityDataModel.DataColumns.FunctionalityId);
var oDT = new DBDataSet("Functionality.DeleteChildren", sql, DataStoreKey);
return(oDT.DBDataset);
}
protected override void Update(Dictionary <string, string> values)
{
var data = new FunctionalityDataModel();
// copies properties from values dictionary object to data object
PropertyMapper.CopyProperties(data, values);
TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Update(data, SessionVariables.RequestProfile);
base.Update(values);
}
public void LoadData(int functionalityId, bool showId)
{
Clear();
var data = new FunctionalityDataModel();
data.FunctionalityId = functionalityId;
var items = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.GetEntityDetails(data, SessionVariables.RequestProfile);
if (items.Count > 1)
{
var item1 = items[0];
txtApplicationId.Text = item1.Application.ToString();
txtName.Text = item1.Name;
txtSortOrder.Text = item1.SortOrder.ToString();
editor.Text = item1.Description;
txtFunctionalityActiveStatusId.Text = item1.FunctionalityActiveStatusId.ToString();;
txtFunctionalityPriorityId.Text = item1.FunctionalityPriorityId.ToString();
//return;
}
var item = items[0];
var applicationInfo = ApplicationCommon.ApplicationCache[SessionVariables.RequestProfile.ApplicationId];
txtApplicationId.Text = applicationInfo.Description;
txtApplicationId.Enabled = false;
drpFunctionalityPriorityList.SelectedValue = item.FunctionalityPriorityId.ToString();
txtFunctionalityPriorityId.Text = item.FunctionalityPriorityId.ToString();
drpFunctionalityActiveStatusList.SelectedValue = item.FunctionalityActiveStatusId.ToString();
txtFunctionalityActiveStatusId.Text = item.FunctionalityActiveStatusId.ToString();
SetData(item);
if (!showId)
{
SystemKeyId = item.FunctionalityId;
oHistoryList.Setup(PrimaryEntity, functionalityId, PrimaryEntityKey);
}
else
{
CoreSystemKey.Text = String.Empty;
}
}
public static bool IsDeletable(FunctionalityDataModel data, RequestProfile requestProfile)
{
var isDeletable = true;
var ds = GetChildren(data, requestProfile);
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables.Cast <DataTable>().Any(dt => dt.Rows.Count > 0))
{
isDeletable = false;
}
}
return(isDeletable);
}
public static string ToSQLParameter(FunctionalityDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case FunctionalityDataModel.DataColumns.FunctionalityId:
if (data.FunctionalityId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityDataModel.DataColumns.FunctionalityId, data.FunctionalityId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityDataModel.DataColumns.FunctionalityId);
}
break;
case FunctionalityDataModel.DataColumns.FunctionalityActiveStatusId:
if (data.FunctionalityActiveStatusId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityDataModel.DataColumns.FunctionalityActiveStatusId, data.FunctionalityActiveStatusId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityDataModel.DataColumns.FunctionalityActiveStatusId);
}
break;
case FunctionalityDataModel.DataColumns.FunctionalityPriorityId:
if (data.FunctionalityPriorityId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityDataModel.DataColumns.FunctionalityPriorityId, data.FunctionalityPriorityId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityDataModel.DataColumns.FunctionalityPriorityId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static void Delete(FunctionalityDataModel dataQuery, RequestProfile requestProfile)
{
const string sql = @"dbo.FunctionalityDelete ";
var parameters =
new
{
AuditId = requestProfile.AuditId
,
FunctionalityId = dataQuery.FunctionalityId
};
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 FunctionalityDataModel();
data.FunctionalityId = int.Parse(index);
if (!TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.IsDeletable(data, SessionVariables.RequestProfile))
{
notDeletableIds.Add(Convert.ToInt32(data.FunctionalityId));
}
}
if (notDeletableIds.Count == 0)
{
foreach (string index in deleteIndexList)
{
var data = new FunctionalityDataModel();
data.FunctionalityId = int.Parse(index);
TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Delete(data, SessionVariables.RequestProfile);
}
Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.Functionality, SessionVariables.RequestProfile);
Response.Redirect(Page.GetRouteUrl("FunctionalityEntityRoute", new { Action = "Default", SetId = true }), false);
}
else
{
var msg = String.Empty;
foreach (var id in notDeletableIds)
{
if (!string.IsNullOrEmpty(msg))
{
msg += ", <br/>";
}
msg += "FunctionalityId: " + id + " has detail records";
}
Response.Write(msg);
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected DataTable GetAssociatedFunctionalityIds(int functionalityEntityStatusId)
{
var data = new FunctionalityEntityStatusDataModel();
data.FunctionalityEntityStatusId = functionalityEntityStatusId;
var results = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Search(data, SessionVariables.RequestProfile);
var fdt = new DataTable();
foreach (DataRow dr in results.Rows)
{
var funcId = dr[FunctionalityEntityStatusDataModel.DataColumns.FunctionalityId].ToString();
var fdata = new FunctionalityDataModel();
fdata.FunctionalityId = int.Parse(funcId);
fdt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Search(fdata, SessionVariables.RequestProfile);
}
//var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.Functionality.GetList(SessionVariables.RequestProfile);
return(fdt);
}
protected override DataTable UpdateData()
{
var UpdatedData = new DataTable();
var data = new FunctionalityDataModel();
UpdatedData = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Search(data, SessionVariables.RequestProfile).Clone();
for (var i = 0; i < SelectedData.Rows.Count; i++)
{
data.FunctionalityId =
Convert.ToInt32(SelectedData.Rows[i][FunctionalityDataModel.DataColumns.FunctionalityId].ToString());
data.FunctionalityActiveStatusId =
Convert.ToInt32(SelectedData.Rows[i][FunctionalityDataModel.DataColumns.FunctionalityActiveStatusId].ToString());
data.FunctionalityPriorityId =
Convert.ToInt32(SelectedData.Rows[i][FunctionalityDataModel.DataColumns.FunctionalityPriorityId].ToString());
data.Name =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.Name))
? CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.Name)
: SelectedData.Rows[i][StandardDataModel.StandardDataColumns.Name].ToString();
data.Description = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.Description))
? CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.Description)
: SelectedData.Rows[i][StandardDataModel.StandardDataColumns.Description].ToString();
data.SortOrder =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.SortOrder))
? int.Parse(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.SortOrder).ToString())
: int.Parse(SelectedData.Rows[i][StandardDataModel.StandardDataColumns.SortOrder].ToString());
TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Update(data, SessionVariables.RequestProfile);
data = new FunctionalityDataModel();
data.FunctionalityId = Convert.ToInt32(SelectedData.Rows[i][FunctionalityDataModel.DataColumns.FunctionalityId].ToString());
var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
UpdatedData.ImportRow(dt.Rows[0]);
}
}
return(UpdatedData);
}
protected void Page_Load(object sender, EventArgs e)
{
int imageId = Convert.ToInt32(Request.QueryString["imageid"]);
var data = new FunctionalityDataModel();
data.FunctionalityId = imageId;
var dt = FunctionalityDataManager.GetDetails(data, SessionVariables.RequestProfile);
if (dt.Rows.Count > 0)
{
if (!dt.Rows[0][FunctionalityImageDataModel.DataColumns.Image].Equals(DBNull.Value))
{
var imageData = ((byte[])(dt.Rows[0][FunctionalityImageDataModel.DataColumns.Image]));
Response.Clear();
Response.ContentType = "image/pjpeg";
Response.BinaryWrite(imageData);
Response.End();
}
}
}
protected override DataTable GetData()
{
try
{
SuperKey = ApplicationCommon.GetSuperKey();
SetId = ApplicationCommon.GetSetId();
var selectedrows = new DataTable();
var functionalitydata = new FunctionalityDataModel();
selectedrows = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.GetDetails(functionalitydata, SessionVariables.RequestProfile).Clone();
if (!string.IsNullOrEmpty(SuperKey))
{
var systemEntityTypeId = (int)PrimaryEntity;
var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey);
foreach (var entityKey in lstEntityKeys)
{
functionalitydata.FunctionalityId = entityKey;
var result = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.GetDetails(functionalitydata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
}
else
{
functionalitydata.FunctionalityId = SetId;
var result = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.GetDetails(functionalitydata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
return(selectedrows);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
return(null);
}
public static void Update(FunctionalityDataModel data, RequestProfile requestedProfile)
{
var sql = CreateOrUpdate(data, requestedProfile, "Update");
DBDML.RunSQL("Functionality.Update", sql, DataStoreKey);
}
public static FunctionalityDataModel GetDetails(FunctionalityDataModel data, RequestProfile requestedProfile)
{
var list = GetEntityDetails(data, requestedProfile);
return(list.FirstOrDefault());
}
private Table BuildReport(int[] entities, int[] functionalities)
{
var edata = new SystemEntityTypeDataModel();
var edt = new DataTable();
var fdata = new FunctionalityDataModel();
var fdt = new DataTable();
var fesdata = new FunctionalityEntityStatusDataModel();
var fesdt = new DataTable();
var table = new Table();
table.CssClass = "entityreport";
table.GridLines = GridLines.Both;
table.BorderColor = System.Drawing.Color.Blue;
table.BorderWidth = 2;
table.BorderStyle = BorderStyle.Groove;
var tablerow = new TableRow();
var tablecell = new TableCell();
tablecell.Text = "Functionality/Entity";
//tablecell.Style.Add("font-weight", "bold");
//tablecell.Style.Add("width", "150px");
tablerow.Cells.Add(tablecell);
for (var i = 0; i < entities.Length; i++)
{
edata.SystemEntityTypeId = entities[i];
edt = Framework.Components.Core.SystemEntityTypeDataManager.Search(edata, SessionVariables.RequestProfile);
tablecell = new TableCell();
if (edt.Rows.Count >= 1)
{
tablecell.Text = edt.Rows[0][SystemEntityTypeDataModel.DataColumns.EntityName].ToString();
//tablecell.Style.Add("font-weight", "bold");
//tablecell.Style.Add("width", "150px");
tablerow.Cells.Add(tablecell);
}
}
table.Rows.Add(tablerow);
tablerow = new TableRow();
for (int j = 0; j < functionalities.Length; j++)
{
fdata.FunctionalityId = functionalities[j];
fdt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Search(fdata, SessionVariables.RequestProfile);
tablerow = new TableRow();
tablecell = new TableCell();
if (fdt.Rows.Count >= 1)
{
tablecell.Text = fdt.Rows[0][StandardDataModel.StandardDataColumns.Name].ToString();
//tablecell.Style.Add("font-weight", "bold");
//tablecell.Style.Add("width", "150px");
tablerow.Cells.Add(tablecell);
}
tablerow.Cells.Add(tablecell);
for (int i = 1; i < table.Rows[0].Cells.Count; i++)
{
tablerow.Cells.Add(new TableCell());
}
table.Rows.Add(tablerow);
}
var entity = "";
var functionality = "";
for (var i = 0; i < functionalities.Length; i++)
{
for (var j = 0; j < entities.Length; j++)
{
fesdata.SystemEntityTypeId = entities[j];
fesdata.FunctionalityId = functionalities[i];
fesdt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Search(fesdata, SessionVariables.RequestProfile);
if (fesdt.Rows.Count == 1)
{
fdata.FunctionalityId = functionalities[i];
fdt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.Search(fdata, SessionVariables.RequestProfile);
if (fdt.Rows.Count >= 1)
{
functionality = fdt.Rows[0][StandardDataModel.StandardDataColumns.Name].ToString();
}
edata.SystemEntityTypeId = entities[j];
edt = Framework.Components.Core.SystemEntityTypeDataManager.Search(edata, SessionVariables.RequestProfile);
if (edt.Rows.Count >= 1)
{
entity = edt.Rows[0][SystemEntityTypeDataModel.DataColumns.EntityName].ToString();
}
for (var k = 1; k < table.Rows.Count; k++)
{
for (int l = 1; l < table.Rows[0].Cells.Count; l++)
{
if (table.Rows[k].Cells[0].Text.Equals(functionality) &&
table.Rows[0].Cells[l].Text.Equals(entity))
{
table.Rows[k].Cells[l].Text = fesdt.Rows[0][FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatus].ToString();
break;
}
}
}
}
}
}
TableReportContent.Controls.Add(table);
return(table);
}
