private DataTable GetData()
{
var data = new FunctionalityEntityStatusDataModel();
var dt = FunctionalityEntityStatusDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
private static string CreateOrUpdate(FunctionalityEntityStatusDataModel data, RequestProfile requestProfile, string action)
{
var sql = "EXEC ";
switch (action)
{
case "Create":
sql += "dbo.FunctionalityEntityStatusInsert ";
break;
case "Update":
sql += "dbo.FunctionalityEntityStatusUpdate ";
break;
default:
break;
}
sql = sql + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityEntityStatusId, data.FunctionalityEntityStatusId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityId, data.FunctionalityId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatusId, data.FunctionalityStatusId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityPriorityId, data.FunctionalityPriorityId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.AssignedTo, data.AssignedTo) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.Memo, data.Memo) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.TargetDate, data.TargetDate) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.StartDate, data.StartDate);
return(sql);
}
public override int?Save(string action)
{
var data = new FunctionalityEntityStatusDataModel();
data.FunctionalityEntityStatusId = FunctionalityEntityStatusId;
data.FunctionalityId = FunctionalityId;
data.FunctionalityPriorityId = FunctionalityPriorityId;
data.FunctionalityStatusId = FunctionalityStatusId;
data.Memo = Memo;
data.StartDate = StartDate;
data.TargetDate = TargetDate;
data.SystemEntityTypeId = SystemEntityTypeId;
data.AssignedTo = AssignedTo;
if (action == "Insert")
{
var dtClient = FunctionalityEntityStatusDataManager.DoesExist(data, SessionVariables.RequestProfile);
if (dtClient.Rows.Count == 0)
{
FunctionalityEntityStatusDataManager.Create(data, SessionVariables.RequestProfile);
}
else
{
throw new Exception("Record with given ID already exists.");
}
}
else
{
FunctionalityEntityStatusDataManager.Update(data, SessionVariables.RequestProfile);
}
// not correct ... when doing insert, we didn't get/change the value of ClientID ?
return(data.FunctionalityEntityStatusId);
}
protected override void ShowData(int functionalityEntityStatusid)
{
oDetailButtonPanel.SetId = SetId;
var data = new FunctionalityEntityStatusDataModel();
data.FunctionalityEntityStatusId = functionalityEntityStatusid;
var items = FunctionalityEntityStatusDataManager.GetEntityDetails(data, SessionVariables.RequestProfile);
if (items.Count == 1)
{
var item = items[0];
lblFunctionalityEntityStatusId.Text = item.FunctionalityEntityStatusId.ToString();
lblSystemEntityTypeId.Text = item.SystemEntityTypeId.ToString();
lblFunctionalityId.Text = Convert.ToString(item.FunctionalityId);
lblFunctionalityStatusId.Text = Convert.ToString(item.FunctionalityStatusId);
lblFunctionalityPriorityId.Text = Convert.ToString(item.FunctionalityPriorityId);
lblAssignedTo.Text = Convert.ToString(item.AssignedTo);
lblMemo.Text = Convert.ToString(item.Memo);
lblTargetDate.Text = Convert.ToString(item.TargetDate);
lblStartDate.Text = Convert.ToString(item.StartDate);
oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction);
oHistoryList.Setup(PrimaryEntity, functionalityEntityStatusid, "FunctionalityEntityStatus");
}
else
{
Clear();
}
}
protected override DataTable UpdateData()
{
var UpdatedData = new DataTable();
var data = new FunctionalityEntityStatusDataModel();
UpdatedData = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Search(data, SessionVariables.RequestProfile).Clone();
for (var i = 0; i < SelectedData.Rows.Count; i++)
{
data.FunctionalityEntityStatusId =
Convert.ToInt32(SelectedData.Rows[i][FunctionalityEntityStatusDataModel.DataColumns.FunctionalityEntityStatusId].ToString());
data.FunctionalityId =
Convert.ToInt32(SelectedData.Rows[i][FunctionalityEntityStatusDataModel.DataColumns.FunctionalityId].ToString());
data.FunctionalityPriorityId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.FunctionalityPriorityId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.FunctionalityPriorityId).ToString())
: int.Parse(SelectedData.Rows[i][FunctionalityEntityStatusDataModel.DataColumns.FunctionalityPriorityId].ToString());
data.FunctionalityStatusId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatusId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatusId).ToString())
: int.Parse(SelectedData.Rows[i][FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatusId].ToString());
data.AssignedTo = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.AssignedTo))
? CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.AssignedTo)
: SelectedData.Rows[i][FunctionalityEntityStatusDataModel.DataColumns.AssignedTo].ToString();
data.Memo =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.Memo))
? CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.Memo)
: SelectedData.Rows[i][FunctionalityEntityStatusDataModel.DataColumns.Memo].ToString();
data.SystemEntityTypeId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.SystemEntityTypeId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.SystemEntityTypeId).ToString())
: int.Parse(SelectedData.Rows[i][FunctionalityEntityStatusDataModel.DataColumns.SystemEntityTypeId].ToString());
data.TargetDate =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.TargetDate))
? DateTime.Parse(CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.TargetDate).ToString())
: DateTime.Parse(SelectedData.Rows[i][FunctionalityEntityStatusDataModel.DataColumns.TargetDate].ToString());
data.StartDate =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.StartDate))
? DateTime.Parse(CheckAndGetRepeaterTextBoxValue(FunctionalityEntityStatusDataModel.DataColumns.StartDate).ToString())
: DateTime.Parse(SelectedData.Rows[i][FunctionalityEntityStatusDataModel.DataColumns.StartDate].ToString());
TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Update(data, SessionVariables.RequestProfile);
data = new FunctionalityEntityStatusDataModel();
data.FunctionalityEntityStatusId = Convert.ToInt32(SelectedData.Rows[i][FunctionalityEntityStatusDataModel.DataColumns.FunctionalityEntityStatusId].ToString());
var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
UpdatedData.ImportRow(dt.Rows[0]);
}
// if everything is done and good THEN move from thsi page.
//Response.Redirect("Default.aspx?Added=" + true, false);
}
return(UpdatedData);
//DynamicUpdatePanel.SetUp(GetColumns(), "FunctionalityEntityStatus", UpdatedData);
}
private System.Data.DataTable GetData()
{
// TODO: on all export pages
var data = new FunctionalityEntityStatusDataModel();
var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
protected override DataTable GetEntityData(int?entityKey)
{
var fesdata = new FunctionalityEntityStatusDataModel();
fesdata.FunctionalityEntityStatusId = entityKey;
var results = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Search(fesdata, SessionVariables.RequestProfile);
return(results);
}
protected DataTable GetAssociatedFunctionalityEntityStatusIds(int functionalityId)
{
var data = new FunctionalityEntityStatusDataModel();
data.FunctionalityId = functionalityId;
var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
private static DataSet GetChildren(FunctionalityEntityStatusDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FunctionalityEntityStatusChildrenGet " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityEntityStatusId, data.FunctionalityEntityStatusId);
var oDT = new DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
private DataTable GetAssociatedFunctionalities(int EntityId)
{
//var id = Convert.ToInt32(drpEntity.SelectedValue);
var id = 0;
var data = new FunctionalityEntityStatusDataModel();
data.SystemEntityTypeId = id;
var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
protected void btnCreate_Click(object sender, EventArgs e)
{
var dataFES = new FunctionalityEntityStatusDataModel();
dataFES.FunctionalityId = FunctionalityId;
var fesData = FunctionalityEntityStatusDataManager.Search(dataFES, SessionVariables.RequestProfile);
if (fesData.Rows.Count == 0)
{
var dtMenu = MenuDataManager.GetList(SessionVariables.RequestProfile);
var entitydt = SystemEntityTypeDataManager.GetList(SessionVariables.RequestProfile);
//get data based on Entity Name from Menu and SystemEntity table to get the Primary Developer value
var assignedTo = from tblMenu in dtMenu.AsEnumerable()
join tblEntity in entitydt.AsEnumerable() on tblMenu.Field <string>(MenuDataModel.DataColumns.Name) equals tblEntity.Field <string>(SystemEntityTypeDataModel.DataColumns.EntityName)
select tblEntity;
//get data from SystemEntity table which doesnt have matching entries in Menu table
var assignedToAdmin = from tblEntity in entitydt.AsEnumerable()
where !assignedTo.Contains(tblEntity)
select tblEntity;
string assignedToValue = string.Empty;
//data inserted to FES with AssignedTo value as PrimaryDeveloper value
for (int i = 0; i < assignedTo.Count(); i++)
{
var primaryDeveloper = from tblMenu in dtMenu.AsEnumerable()
join tblEntity in entitydt.AsEnumerable() on tblMenu.Field <string>(MenuDataModel.DataColumns.Name) equals tblEntity.Field <string>(SystemEntityTypeDataModel.DataColumns.EntityName)
where tblMenu.Field <string>(MenuDataModel.DataColumns.Name) == assignedTo.CopyToDataTable().Rows[i][SystemEntityTypeDataModel.DataColumns.EntityName].ToString()
select tblMenu[MenuDataModel.DataColumns.PrimaryDeveloper];
assignedToValue = primaryDeveloper.First().ToString();
Insert(assignedTo.CopyToDataTable().Rows[i], assignedToValue);
}
//data inserted to FES with AssignedTo value as "Admin"
for (int j = 0; j < assignedToAdmin.Count(); j++)
{
assignedToValue = "Admin";
Insert(assignedToAdmin.CopyToDataTable().Rows[j], assignedToValue);
}
}
}
public static bool DoesExist(FunctionalityEntityStatusDataModel data, RequestProfile requestProfile)
{
var doesExistRequest = new FunctionalityEntityStatusDataModel();
doesExistRequest.SystemEntityTypeId = data.SystemEntityTypeId;
doesExistRequest.FunctionalityId = data.FunctionalityId;
doesExistRequest.FunctionalityStatusId = data.FunctionalityStatusId;
doesExistRequest.FunctionalityPriorityId = data.FunctionalityPriorityId;
var list = GetEntityDetails(doesExistRequest, requestProfile, 0);
return(list.Count > 0);
}
private void Update(Dictionary <string, string> values)
{
var data = new FunctionalityEntityStatusDataModel();
data.FunctionalityEntityStatusId = int.Parse(values[FunctionalityEntityStatusDataModel.DataColumns.FunctionalityEntityStatusId].ToString());
data.AssignedTo = values[FunctionalityEntityStatusDataModel.DataColumns.AssignedTo].ToString();
data.Memo = values[FunctionalityEntityStatusDataModel.DataColumns.Memo].ToString();
data.TargetDate = DateTime.Parse(values[FunctionalityEntityStatusDataModel.DataColumns.TargetDate].ToString());
data.StartDate = DateTime.Parse(values[FunctionalityEntityStatusDataModel.DataColumns.StartDate].ToString());
data.SystemEntityTypeId = int.Parse(values[FunctionalityEntityStatusDataModel.DataColumns.SystemEntityTypeId].ToString());
data.FunctionalityId = int.Parse(values[FunctionalityEntityStatusDataModel.DataColumns.FunctionalityId].ToString());
data.FunctionalityPriorityId = int.Parse(values[FunctionalityEntityStatusDataModel.DataColumns.FunctionalityPriorityId].ToString());
data.FunctionalityStatusId = int.Parse(values[FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatusId].ToString());
TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Update(data, SessionVariables.RequestProfile);
InlineEditingList.Data = GetData();
}
protected override void Clear()
{
base.Clear();
var data = new FunctionalityEntityStatusDataModel();
FunctionalityEntityStatusId = data.FunctionalityEntityStatusId;
FunctionalityId = data.FunctionalityId;
FunctionalityPriorityId = data.FunctionalityPriorityId;
FunctionalityStatusId = data.FunctionalityStatusId;
SystemEntityTypeId = data.SystemEntityTypeId;
AssignedTo = data.AssignedTo;
Memo = data.Memo;
TargetDate = data.TargetDate;
StartDate = data.StartDate;
}
public static void Delete(FunctionalityEntityStatusDataModel dataQuery, RequestProfile requestProfile)
{
const string sql = @"dbo.FunctionalityEntityStatusDelete ";
var parameters =
new
{
AuditId = requestProfile.AuditId
,
FunctionalityEntityStatusId = dataQuery.FunctionalityEntityStatusId
};
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure);
}
}
private DataTable GetData()
{
try
{
var superKey = ApplicationCommon.GetSuperKey();
var setId = ApplicationCommon.GetSetId();
var selectedrows = new DataTable();
var FunctionalityEntityStatusdata = new FunctionalityEntityStatusDataModel();
selectedrows = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.GetDetails(FunctionalityEntityStatusdata, SessionVariables.RequestProfile).Clone();
if (!string.IsNullOrEmpty(superKey))
{
var data = new SuperKeyDetailDataModel();
data.SuperKeyId = Convert.ToInt32(superKey);
// Change System Entity Type
data.SystemEntityTypeId = (int)Framework.Components.DataAccess.SystemEntity.FunctionalityEntityStatus;
var dt = Framework.Components.Core.SuperKeyDetailDataManager.Search(data, SessionVariables.RequestProfile);
if (dt != null && dt.Rows.Count > 0)
{
var keys = new int[dt.Rows.Count];
for (var i = 0; i < dt.Rows.Count; i++)
{
keys[i] = Convert.ToInt32(dt.Rows[i][SuperKeyDetailDataModel.DataColumns.EntityKey]);
FunctionalityEntityStatusdata.FunctionalityEntityStatusId = keys[i];
var result = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.GetDetails(FunctionalityEntityStatusdata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
}
}
else
{
var key = setId;
FunctionalityEntityStatusdata.FunctionalityEntityStatusId = key;
var result = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.GetDetails(FunctionalityEntityStatusdata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
return(selectedrows);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
return(null);
}
public static bool IsDeletable(FunctionalityEntityStatusDataModel 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 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);
}
private void SaveByEntity(int EntityId, List <int> FunctionalityIds)
{
var id = 0;
var data = new FunctionalityEntityStatusDataModel();
data.SystemEntityTypeId = EntityId;
var funcids = FunctionalityIds.ToArray();
for (var i = 0; i < funcids.Length; i++)
{
var fesdata = new FunctionalityEntityStatusDataModel();
fesdata.FunctionalityId = funcids[i];
fesdata.SystemEntityTypeId = EntityId;
var fesdt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Search(fesdata, SessionVariables.RequestProfile);
if (fesdt.Rows.Count == 0)
{
TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Create(fesdata, SessionVariables.RequestProfile);
}
}
}
public void Insert(DataRow dtRow, string assignedTo)
{
var data = new FunctionalityEntityStatusDataModel();
data.SystemEntityTypeId = Convert.ToInt32(dtRow[SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId]);
data.ApplicationId = Convert.ToInt32(ddlApplication.SelectedValue);
data.FunctionalityId = FunctionalityId;
data.Memo = Functionality;;
data.AssignedTo = assignedTo;
data.FunctionalityPriorityId = ApplicationCommon.FunctionalityPriority;
data.FunctionalityStatusId = ApplicationCommon.FunctionalityStatus;
data.StartDate = DateTime.Now;
data.TargetDate = DateTime.Now.AddDays(7);
var dtFES = FunctionalityEntityStatusDataManager.DoesExist(data, SessionVariables.RequestProfile);
if (dtFES.Rows.Count == 0)
{
FunctionalityEntityStatusDataManager.Create(data, SessionVariables.RequestProfile);
}
}
public static List <FunctionalityEntityStatusDataModel> GetEntityDetails(FunctionalityEntityStatusDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.FunctionalityEntityStatusSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, FunctionalityEntityStatusId = dataQuery.FunctionalityEntityStatusId
, ReturnAuditInfo = returnAuditInfo
, ApplicationId = dataQuery.ApplicationId
};
List <FunctionalityEntityStatusDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <FunctionalityEntityStatusDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public static DataTable Search(FunctionalityEntityStatusDataModel data, RequestProfile requestProfile)
{
var mergeddt = new DataTable();
var procSql = string.Empty;
var sql = string.Empty;
if (data.FunctionalityActiveStatusId != null)
{
procSql = "EXEC dbo.FESModuleIntegratedSearch ";
}
else
{
procSql = "EXEC dbo.FunctionalityEntityStatusSearch ";
}
if (data.FunctionalityStatusIds != null && data.FunctionalityStatusIds.Length >= 1)
{
for (int i = 0; i < data.FunctionalityStatusIds.Length; i++)
{
sql = procSql +
" " + BaseDataManager.SetCommonParametersForSearch(requestProfile.AuditId, requestProfile.ApplicationId, requestProfile.ApplicationModeId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityEntityStatusId, data.FunctionalityEntityStatusId) +
//", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.ApplicationId, data.ApplicationId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityId, data.FunctionalityId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityPriorityId, data.FunctionalityPriorityId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatusId, data.FunctionalityStatusIds[i]) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityActiveStatusId, data.FunctionalityActiveStatusId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.AssignedTo, data.AssignedTo) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.StartDate, data.StartDate) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.TargetDate, data.TargetDate) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.StartDate2, data.StartDateR2) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationMode, requestProfile.ApplicationModeId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.TargetDate2, data.TargetDateR2);
var oDT = new DBDataTable("FunctionalityEntityStatus.Search", sql, DataStoreKey);
var dt = new DataTable();
dt = oDT.DBTable;
if (mergeddt.Rows.Count == 0)
{
mergeddt = dt.Clone();
}
foreach (DataRow row in dt.Rows)
{
mergeddt.ImportRow(row);
}
}
return(mergeddt);
}
else
{
// formulate SQL
sql = procSql +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.ApplicationId, data.ApplicationId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityEntityStatusId, data.FunctionalityEntityStatusId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityId, data.FunctionalityId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityPriorityId, data.FunctionalityPriorityId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatusId, data.FunctionalityStatusId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityActiveStatusId, data.FunctionalityActiveStatusId) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.AssignedTo, data.AssignedTo) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.StartDate, data.StartDate) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.TargetDate, data.TargetDate) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.StartDate2, data.StartDateR2) +
", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.TargetDate2, data.TargetDateR2);
var oDT = new DBDataTable("FunctionalityEntityStatus.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
}
public static FunctionalityEntityStatusDataModel GetDetails(FunctionalityEntityStatusDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile);
return(list.FirstOrDefault());
}
public void LoadData(int functionalityEntityStatusid, bool showId)
{
// clear UI
Clear();
// set up parameters
var data = new FunctionalityEntityStatusDataModel();
data.FunctionalityEntityStatusId = functionalityEntityStatusid;
// get data
var items = FunctionalityEntityStatusDataManager.GetEntityDetails(data, SessionVariables.RequestProfile);
// should only have single match -- should log exception.
if (items.Count != 1)
{
return;
}
var item = items[0];
txtFunctionalityEntityStatusId.Text = item.FunctionalityEntityStatusId.ToString();
txtFunctionalityId.Text = item.FunctionalityId.ToString();
txtFunctionalityPriorityId.Text = item.FunctionalityPriorityId.ToString();
txtFunctionalityStatusId.Text = item.FunctionalityStatusId.ToString();
txtSystemEntityTypeId.Text = item.SystemEntityTypeId.ToString();
txtAssignedTo.Text = item.AssignedTo;
txtMemo.Text = item.Memo;
txtTargetDate.Text = item.TargetDate.Value.ToString(SessionVariables.UserDateFormat);
txtStartDate.Text = item.StartDate.Value.ToString(SessionVariables.UserDateFormat);
drpSystemEntityTypeList.SelectedValue = item.SystemEntityTypeId.ToString();
drpFunctionalityList.SelectedValue = item.FunctionalityId.ToString();
drpFunctionalityStatusList.SelectedValue = item.FunctionalityStatusId.ToString();
drpFunctionalityPriorityList.SelectedValue = item.FunctionalityPriorityId.ToString();
if (!showId)
{
txtFunctionalityEntityStatusId.Text = item.FunctionalityEntityStatusId.ToString();
//PlaceHolderAuditHistory.Visible = true;
// only show Audit History in case of Update page, not for Clone.
oHistoryList.Setup(PrimaryEntity, functionalityEntityStatusid, PrimaryEntityKey);
var listControl = (DetailsWithChildrenControl)Page.LoadControl(ApplicationCommon.DetailsWithChildrenListControl);
listControl.Setup("FunctionalityEntityStatusArchive", "", "FunctionalityEntityStatusArchiveId", functionalityEntityStatusid, true, GetData, GetFunctionalityEntityStatusArchiveColumns, "FunctionalityEntityStatusArchive");
listControl.SetSession("true");
listControl.HideControls();
plcControlHolder.Controls.Add(listControl);
plcControlHolder.Controls.Add(new Literal()
{
Text = "<br />"
});
}
else
{
txtFunctionalityEntityStatusId.Text = String.Empty;
}
oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction);
}
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 FunctionalityEntityStatusDataModel();
data.FunctionalityEntityStatusId = int.Parse(index);
if (!TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.IsDeletable(data, SessionVariables.RequestProfile))
{
notDeletableIds.Add(Convert.ToInt32(data.FunctionalityEntityStatusId));
}
}
if (notDeletableIds.Count == 0)
{
foreach (string index in deleteIndexList)
{
var data = new FunctionalityEntityStatusDataModel();
data.FunctionalityEntityStatusId = int.Parse(index);
TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Delete(data, SessionVariables.RequestProfile);
}
Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.FunctionalityEntityStatus, SessionVariables.RequestProfile);
Response.Redirect(Page.GetRouteUrl("FunctionalityEntityStatusEntityRoute", new { Action = "Default", SetId = true }), false);
}
else
{
var msg = String.Empty;
foreach (var id in notDeletableIds)
{
if (!string.IsNullOrEmpty(msg))
{
msg += ", <br/>";
}
msg += "FunctionalityEntityStatusId: " + id + " has detail records";
var data = new FunctionalityEntityStatusArchiveDataModel();
data.FunctionalityEntityStatusId = id;
var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusArchiveDataManager.Search(data, SessionVariables.RequestProfile);
foreach (DataRow dr in dt.Rows)
{
var fesarchid = int.Parse(dr[FunctionalityEntityStatusArchiveDataModel.DataColumns.FunctionalityEntityStatusArchiveId].ToString());
data.FunctionalityEntityStatusArchiveId = fesarchid;
TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusArchiveDataManager.Delete(data, SessionVariables.RequestProfile);
}
var fesdata = new FunctionalityEntityStatusDataModel();
fesdata.FunctionalityEntityStatusId = id;
TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityEntityStatusDataManager.Delete(fesdata, SessionVariables.RequestProfile);
Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(id.ToString(), (int)Framework.Components.DataAccess.SystemEntity.FunctionalityEntityStatus, SessionVariables.RequestProfile);
Response.Redirect(Page.GetRouteUrl("FunctionalityEntityStatusEntityRoute", new { Action = "Default", SetId = true }), false);
}
Response.Write(msg);
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
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);
}
public static string ToSQLParameter(FunctionalityEntityStatusDataModel data, string dataColumnName, object value)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case FunctionalityEntityStatusDataModel.DataColumns.FunctionalityEntityStatusId:
if (data.FunctionalityEntityStatusId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityEntityStatusId, data.FunctionalityEntityStatusId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityEntityStatusId);
}
break;
case FunctionalityEntityStatusDataModel.DataColumns.ApplicationId:
if (data.ApplicationId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityEntityStatusDataModel.DataColumns.ApplicationId, data.ApplicationId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusDataModel.DataColumns.ApplicationId);
}
break;
case FunctionalityEntityStatusDataModel.DataColumns.FunctionalityId:
if (data.FunctionalityId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityId, data.FunctionalityId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityId);
}
break;
case FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatusId:
if (value != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatusId, value);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatusId);
}
break;
case FunctionalityEntityStatusDataModel.DataColumns.FunctionalityPriorityId:
if (data.FunctionalityPriorityId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityPriorityId, data.FunctionalityPriorityId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityPriorityId);
}
break;
case FunctionalityEntityStatusDataModel.DataColumns.FunctionalityActiveStatusId:
if (data.FunctionalityActiveStatusId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityActiveStatusId, data.FunctionalityActiveStatusId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityActiveStatusId);
}
break;
case FunctionalityEntityStatusDataModel.DataColumns.Memo:
if (data.Memo != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityEntityStatusDataModel.DataColumns.Memo, data.Memo);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusDataModel.DataColumns.Memo);
}
break;
case FunctionalityEntityStatusDataModel.DataColumns.SystemEntityTypeId:
if (data.SystemEntityTypeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityEntityStatusDataModel.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusDataModel.DataColumns.SystemEntityTypeId);
}
break;
case FunctionalityEntityStatusDataModel.DataColumns.StartDate:
if (data.StartDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityEntityStatusDataModel.DataColumns.StartDate, data.StartDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusDataModel.DataColumns.StartDate);
}
break;
case FunctionalityEntityStatusDataModel.DataColumns.StartDate2:
if (data.StartDateR2 != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityEntityStatusDataModel.DataColumns.StartDate2, data.StartDateR2);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusDataModel.DataColumns.StartDate2);
}
break;
case FunctionalityEntityStatusDataModel.DataColumns.TargetDate:
if (data.TargetDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityEntityStatusDataModel.DataColumns.TargetDate, data.TargetDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusDataModel.DataColumns.TargetDate);
}
break;
case FunctionalityEntityStatusDataModel.DataColumns.TargetDate2:
if (data.TargetDateR2 != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityEntityStatusDataModel.DataColumns.TargetDate2, data.TargetDateR2);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusDataModel.DataColumns.TargetDate2);
}
break;
case FunctionalityEntityStatusDataModel.DataColumns.AssignedTo:
if (data.AssignedTo != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityEntityStatusDataModel.DataColumns.AssignedTo, data.AssignedTo);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusDataModel.DataColumns.AssignedTo);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static void Update(FunctionalityEntityStatusDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Update");
DBDML.RunSQL("FunctionalityEntityStatus.Update", sql, DataStoreKey);
}
