protected override DataTable UpdateData()
{
var UpdatedData = new DataTable();
var data = new NeedDataModel();
UpdatedData = NeedDataManager.Search(data, SessionVariables.RequestProfile).Clone();
for (var i = 0; i < SelectedData.Rows.Count; i++)
{
data.NeedId =
Convert.ToInt32(SelectedData.Rows[i][NeedDataModel.DataColumns.NeedId].ToString());
data.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());
NeedDataManager.Update(data, SessionVariables.RequestProfile);
data = new NeedDataModel();
data.NeedId = Convert.ToInt32(SelectedData.Rows[i][NeedDataModel.DataColumns.NeedId].ToString());
var dt = NeedDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
UpdatedData.ImportRow(dt.Rows[0]);
}
}
return(UpdatedData);
}
public void LoadData(int needId, bool showId)
{
Clear();
var data = new NeedDataModel();
data.NeedId = needId;
var items = NeedDataManager.GetEntityDetails(data, SessionVariables.RequestProfile);
if (items.Count != 1)
{
return;
}
var item = items[0];
SetData(item);
if (!showId)
{
SystemKeyId = item.NeedId;
oHistoryList.Setup(PrimaryEntity, needId, PrimaryEntityKey);
}
else
{
CoreSystemKey.Text = String.Empty;
}
}
public override int?Save(string action)
{
var data = new NeedDataModel();
data.NeedId = SystemKeyId;
data.Name = Name;
data.Description = Description;
data.SortOrder = SortOrder;
if (action == "Insert")
{
var dtNeed = NeedDataManager.DoesExist(data, SessionVariables.RequestProfile);
if (dtNeed.Rows.Count == 0)
{
NeedDataManager.Create(data, SessionVariables.RequestProfile);
}
else
{
throw new Exception("Record with given ID already exists.");
}
}
else
{
NeedDataManager.Update(data, SessionVariables.RequestProfile);
}
return(data.NeedId);
}
private DataTable GetData()
{
// TODO: on all export pages
var data = new NeedDataModel();
var dt = NeedDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
protected override DataTable GetEntityData(int?entityKey)
{
var needdata = new NeedDataModel();
needdata.NeedId = entityKey;
var results = NeedDataManager.Search(needdata, SessionVariables.RequestProfile);
return(results);
}
protected override void Update(Dictionary <string, string> values)
{
var data = new NeedDataModel();
// copies properties from values dictionary object to data object
PropertyMapper.CopyProperties(data, values);
NeedDataManager.Update(data, SessionVariables.RequestProfile);
base.Update(values);
}
private void UpdateData(ArrayList values)
{
var data = new NeedDataModel();
data.NeedId = int.Parse(values[0].ToString());
data.Name = values[1].ToString();
data.Description = values[2].ToString();
data.SortOrder = int.Parse(values[3].ToString());
NeedDataManager.Update(data, SessionVariables.RequestProfile);
ReBindEditableGrid();
}
private DataTable GetNeedData(int projectId)
{
var dt = ProjectXNeedDataManager.GetByProject(projectId, SessionVariables.RequestProfile.AuditId);
var needdt = NeedDataManager.GetList(SessionVariables.RequestProfile);
var resultdt = needdt.Clone();
foreach (DataRow row in dt.Rows)
{
var rows = needdt.Select("NeedId = " + row[NeedDataModel.DataColumns.NeedId]);
resultdt.ImportRow(rows[0]);
}
return(resultdt);
}
private int GetNextValidId(int tempId)
{
var dt = NeedDataManager.GetList(SessionVariables.RequestProfile);
foreach (DataRow dr in dt.Rows)
{
if (dr[NeedDataModel.DataColumns.NeedId].ToString().Equals(tempId.ToString()))
{
tempId -= 1;
return(GetNextValidId(tempId));
}
}
return(tempId);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
string[] deleteIndexList = DeleteIds.Split(',');
foreach (string index in deleteIndexList)
{
var data = new NeedDataModel();
data.NeedId = int.Parse(index);
NeedDataManager.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 needdata = new NeedDataModel();
selectedrows = NeedDataManager.GetDetails(needdata, SessionVariables.RequestProfile).Clone();
if (!string.IsNullOrEmpty(SuperKey))
{
var systemEntityTypeId = (int)PrimaryEntity;
var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey);
foreach (var entityKey in lstEntityKeys)
{
needdata.NeedId = entityKey;
var result = NeedDataManager.GetDetails(needdata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
}
else
{
needdata.NeedId = SetId;
var result = NeedDataManager.GetDetails(needdata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
return(selectedrows);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
return(null);
}
protected override void ShowData(int needId)
{
base.ShowData(needId);
oDetailButtonPanel.SetId = SetId;
Clear();
var data = new NeedDataModel();
data.NeedId = needId;
var items = NeedDataManager.GetEntityDetails(data, SessionVariables.RequestProfile);
if (items.Count == 1)
{
var item = items[0];
SetData(item);
oHistoryList.Setup(PrimaryEntity, needId, "Need");
}
}
private void ReBindEditableGrid()
{
var data = new NeedDataModel();
var dtNeed = NeedDataManager.Search(data, SessionVariables.RequestProfile);
}
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);
}
}
protected override DataTable GetData()
{
var dt = NeedDataManager.Search(oSearchFilter.SearchParameters, SessionVariables.RequestProfile);
return(dt);
}
private DataTable GetNeedList()
{
var dt = NeedDataManager.GetList(SessionVariables.RequestProfile);
return(dt);
}
protected override void OnInit(EventArgs e)
{
try
{
var superKey = "";
var newId = SystemEntityTypeDataManager.GetNextSequence("Need", (int)SystemEntity.Need, SessionVariables.RequestProfile);
var Needdata = new NeedDataModel();
var systemdevdata = new SystemDevNumbersDataModel();
systemdevdata.ApplicationUserId = SessionVariables.RequestProfile.AuditId;
var dtnumbers = SystemDevNumbersDataManager.Search(systemdevdata, SessionVariables.RequestProfile);
var rangefrom =
Convert.ToInt32(dtnumbers.Rows[0][SystemDevNumbersDataModel.DataColumns.RangeFrom].ToString());
var rangeto =
Convert.ToInt32(dtnumbers.Rows[0][SystemDevNumbersDataModel.DataColumns.RangeTo].ToString());
if (Request.QueryString["SuperKey"] != null)
{
superKey = Request.QueryString["SuperKey"].ToString();
var data = new SuperKeyDetailDataModel();
data.SuperKeyId = Convert.ToInt32(superKey);
data.SystemEntityTypeId = (int)SystemEntity.Need;
var dt = SuperKeyDetailDataManager.Search(data, SessionVariables.RequestProfile);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var key = Convert.ToInt32(dr[SuperKeyDetailDataModel.DataColumns.EntityKey]);
Needdata.NeedId = key;
var Needdt = NeedDataManager.GetDetails(Needdata, SessionVariables.RequestProfile);
if (Needdt.Rows.Count == 1)
{
var row = Needdt.Rows[0];
if (Request.QueryString["Mode"].ToString().Equals("Test"))
{
Needdata.NeedId = GetNextValidId(rangefrom);
}
Needdata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]);
Needdata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]);
Needdata.SortOrder = Convert.ToInt32(row[StandardDataModel.StandardDataColumns.SortOrder]);
NeedDataManager.Create(Needdata, SessionVariables.RequestProfile);
}
}
}
}
else if (Request.QueryString["SetId"] != null)
{
var key = int.Parse(Request.QueryString["SetId"]);
Needdata.NeedId = key;
var Needdt = NeedDataManager.GetDetails(Needdata, SessionVariables.RequestProfile);
if (Needdt.Rows.Count == 1)
{
var row = Needdt.Rows[0];
var newNeeddata = new NeedDataModel();
if (Request.QueryString["Mode"].ToString().Equals("Test"))
{
newNeeddata.NeedId = newId = (int)GetNextValidId(rangefrom);
}
newNeeddata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]);
newNeeddata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]);
newNeeddata.SortOrder = Convert.ToInt32(row[StandardDataModel.StandardDataColumns.SortOrder]);
UpdatedFKDepenedencies(key, newId);
NeedDataManager.Delete(Needdata, SessionVariables.RequestProfile);
NeedDataManager.Create(newNeeddata, SessionVariables.RequestProfile);
}
}
else if (Request.QueryString["Mode"].ToString().Equals("Renumber"))
{
var seed = int.Parse(Request.QueryString["Seed"].ToString());
//ApplicationVariables.Seed;
var increment = int.Parse(Request.QueryString["Increment"].ToString());
//ApplicationVariables.Increment;
NeedDataManager.Renumber(seed, increment, SessionVariables.RequestProfile);
}
base.OnInit(e);
Response.Redirect("Default.aspx?Added=true", false);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
