private static string Save(SystemDevNumbersDataModel data, RequestProfile requestProfile, string action)
{
var sql = "EXEC ";
switch (action)
{
case "Create":
sql += "dbo.SystemDevNumbersInsert " + "\r\n" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
break;
case "Update":
sql += "dbo.SystemDevNumbersUpdate " + "\r\n" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
break;
default:
break;
}
sql = sql + ", " + ToSQLParameter(data, SystemDevNumbersDataModel.DataColumns.SystemDevNumbersId) +
", " + ToSQLParameter(data, SystemDevNumbersDataModel.DataColumns.Description) +
", " + ToSQLParameter(data, SystemDevNumbersDataModel.DataColumns.PersonId) +
", " + ToSQLParameter(data, SystemDevNumbersDataModel.DataColumns.RangeFrom) +
", " + ToSQLParameter(data, SystemDevNumbersDataModel.DataColumns.RangeTo);
return(sql);
}
private DataTable GetData(string name)
{
var data = new SystemDevNumbersDataModel();
var dt = Framework.Components.Core.SystemDevNumbersDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
protected override void ShowData(int systemDevNumbersId)
{
oDetailButtonPanel.SetId = SetId;
var data = new SystemDevNumbersDataModel();
data.SystemDevNumbersId = systemDevNumbersId;
var dt = Framework.Components.Core.SystemDevNumbersDataManager.GetDetails(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
var row = dt.Rows[0];
lblSystemDevNumbersId.Text = Convert.ToString(row[SystemDevNumbersDataModel.DataColumns.SystemDevNumbersId]);
lblPerson.Text = Convert.ToString(row[SystemDevNumbersDataModel.DataColumns.Person]);
lblRangeFrom.Text = Convert.ToString(row[SystemDevNumbersDataModel.DataColumns.RangeFrom]);
lblRangeTo.Text = Convert.ToString(row[SystemDevNumbersDataModel.DataColumns.RangeTo]);
oUpdateInfo.LoadText(dt.Rows[0]);
oHistoryList.Setup("AuditHistory", "Audit", "AuditHistoryId", true, true, (int)Framework.Components.DataAccess.SystemEntity.SystemDevNumbers, systemDevNumbersId, "SystemDevNumbers");
dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "SystemDevNumbers");
}
else
{
Clear();
}
}
public static DataTable DoesExist(SystemDevNumbersDataModel data, RequestProfile requestProfile)
{
var doesExistRequest = new SystemDevNumbersDataModel();
doesExistRequest.PersonId = data.PersonId;
return(Search(doesExistRequest, requestProfile));
}
private System.Data.DataTable GetData()
{
// TODO: on all export pages
var data = new SystemDevNumbersDataModel();
var dt = Framework.Components.Core.SystemDevNumbersDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
public static bool DoesExist(SystemDevNumbersDataModel data, RequestProfile requestProfile)
{
var doesExistRequest = new SystemDevNumbersDataModel();
doesExistRequest.PersonId = data.PersonId;
var list = Search(doesExistRequest, requestProfile);
return(list.Rows.Count > 0);
}
public static DataTable GetDetails(SystemDevNumbersDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.SystemDevNumbersSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ReturnAuditInfo, ReturnAuditInfoOnDetails) +
", " + ToSQLParameter(data, SystemDevNumbersDataModel.DataColumns.SystemDevNumbersId);
var oDT = new DBDataTable("Get Details", sql, DataStoreKey);
return(oDT.DBTable);
}
protected override void InsertData()
{
var data = new SystemDevNumbersDataModel();
data.SystemDevNumbersId = myGenericControl.SystemDevNumbersId;
data.PersonId = myGenericControl.PersonId;
data.RangeFrom = myGenericControl.RangeFrom;
data.RangeTo = myGenericControl.RangeTo;
Framework.Components.Core.SystemDevNumbersDataManager.Create(data, SessionVariables.RequestProfile);
}
public static DataTable Search(SystemDevNumbersDataModel data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.SystemDevNumbersSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationMode, requestProfile.ApplicationModeId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, SystemDevNumbersDataModel.DataColumns.ApplicationUserId) +
", " + ToSQLParameter(data, SystemDevNumbersDataModel.DataColumns.SystemDevNumbersId);
var oDT = new DBDataTable("Get List", sql, DataStoreKey);
return(oDT.DBTable);
}
public static void Delete(SystemDevNumbersDataModel dataQuery, RequestProfile requestProfile)
{
const string sql = @"dbo.SystemDevNumbersDelete ";
var parameters =
new
{
AuditId = requestProfile.AuditId
,
SystemDevNumbersId = dataQuery.SystemDevNumbersId
};
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
string[] deleteIndexList = DeleteIds.Split(',');
foreach (string index in deleteIndexList)
{
var data = new SystemDevNumbersDataModel();
data.SystemDevNumbersId = int.Parse(index);
Framework.Components.Core.SystemDevNumbersDataManager.Delete(data, SessionVariables.RequestProfile);
}
Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.SystemDevNumbers, SessionVariables.RequestProfile);
Response.Redirect(Page.GetRouteUrl("SystemDevNumbersEntityRoute", new { Action = "Default", SetId = true }), false);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
public void LoadData(int systemDevNumbersId, bool showId)
{
var data = new SystemDevNumbersDataModel();
data.SystemDevNumbersId = systemDevNumbersId;
var oSystemDevNumbersTable = Framework.Components.Core.SystemDevNumbersDataManager.GetDetails(data, SessionVariables.RequestProfile);
if (oSystemDevNumbersTable.Rows.Count == 1)
{
var row = oSystemDevNumbersTable.Rows[0];
if (!showId)
{
txtSystemDevNumbersId.Text = Convert.ToString(row[SystemDevNumbersDataModel.DataColumns.SystemDevNumbersId]);
dynAuditHistory.Visible = true;
// only show Audit History in case of Update page, not for Clone.
oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.SystemDevNumbers, systemDevNumbersId, "SystemDevNumbers");
dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "SystemDevNumbers");
}
else
{
txtSystemDevNumbersId.Text = String.Empty;
}
txtRangeFrom.Text = Convert.ToString(row[SystemDevNumbersDataModel.DataColumns.RangeFrom]);
txtRangeTo.Text = Convert.ToString(row[SystemDevNumbersDataModel.DataColumns.RangeTo]);
txtPersonId.Text = Convert.ToString(row[SystemDevNumbersDataModel.DataColumns.PersonId]);
drpPerson.SelectedValue = Convert.ToString(row[SystemDevNumbersDataModel.DataColumns.PersonId]);
}
else
{
txtSystemDevNumbersId.Text = String.Empty;
txtRangeFrom.Text = String.Empty;
txtRangeTo.Text = String.Empty;
txtPersonId.Text = String.Empty;
}
}
public static List <SystemDevNumbersDataModel> GetEntityDetails(SystemDevNumbersDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.SystemDevNumbersSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationId = requestProfile.ApplicationId
, ReturnAuditInfo = returnAuditInfo
, ApplicationUserId = dataQuery.ApplicationUserId
, SystemDevNumbersId = dataQuery.SystemDevNumbersId
};
List <SystemDevNumbersDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <SystemDevNumbersDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
protected override void OnInit(EventArgs e)
{
try
{
var superKey = "";
var newId = Framework.Components.Core.SystemEntityTypeDataManager.GetNextSequence("TestRun", (int)Framework.Components.DataAccess.SystemEntity.TestRun, SessionVariables.RequestProfile);
var TestRundata = new TestRunDataModel();
var systemdevdata = new SystemDevNumbersDataModel();
systemdevdata.ApplicationUserId = SessionVariables.RequestProfile.AuditId;
var dtnumbers = Framework.Components.Core.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)Framework.Components.DataAccess.SystemEntity.TestRun;
var dt = Framework.Components.Core.SuperKeyDetailDataManager.Search(data, SessionVariables.RequestProfile);
if (dt != null && dt.Rows.Count > 0)
{
foreach (System.Data.DataRow dr in dt.Rows)
{
var key = Convert.ToInt32(dr[SuperKeyDetailDataModel.DataColumns.EntityKey]);
TestRundata.TestRunId = key;
var TestRundt = TestCaseManagement.Components.DataAccess.TestRunDataManager.GetDetails(TestRundata, SessionVariables.RequestProfile);
if (TestRundt.Rows.Count == 1)
{
var row = TestRundt.Rows[0];
if (Request.QueryString["Mode"].ToString().Equals("Test"))
{
TestRundata.TestRunId = GetNextValidId(rangefrom);
}
TestRundata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]);
TestRundata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]);
TestRundata.SortOrder = Convert.ToInt32(row[StandardDataModel.StandardDataColumns.SortOrder]);
TestCaseManagement.Components.DataAccess.TestRunDataManager.Create(TestRundata, SessionVariables.RequestProfile);
}
}
}
}
else if (Request.QueryString["SetId"] != null)
{
var key = int.Parse(Request.QueryString["SetId"]);
TestRundata.TestRunId = key;
var TestRundt = TestCaseManagement.Components.DataAccess.TestRunDataManager.GetDetails(TestRundata, SessionVariables.RequestProfile);
if (TestRundt.Rows.Count == 1)
{
var row = TestRundt.Rows[0];
var newTestRundata = new TestRunDataModel();
if (Request.QueryString["Mode"].ToString().Equals("Test"))
{
newTestRundata.TestRunId = newId = (int)GetNextValidId(rangefrom);
}
newTestRundata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]);
newTestRundata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]);
newTestRundata.SortOrder = Convert.ToInt32(row[StandardDataModel.StandardDataColumns.SortOrder]);
// UpdatedFKDepenedencies(key, newId);
TestCaseManagement.Components.DataAccess.TestRunDataManager.Delete(TestRundata, SessionVariables.RequestProfile);
TestCaseManagement.Components.DataAccess.TestRunDataManager.Create(newTestRundata, 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;
TestCaseManagement.Components.DataAccess.TestRunDataManager.Renumber(seed, increment, SessionVariables.RequestProfile);
}
base.OnInit(e);
Response.Redirect("Default.aspx?Added=true", false);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
public static SystemDevNumbersDataModel GetDetails(SystemDevNumbersDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 1);
return(list.FirstOrDefault());
}
public static string ToSQLParameter(SystemDevNumbersDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case SystemDevNumbersDataModel.DataColumns.SystemDevNumbersId:
if (data.SystemDevNumbersId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SystemDevNumbersDataModel.DataColumns.SystemDevNumbersId, data.SystemDevNumbersId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemDevNumbersDataModel.DataColumns.SystemDevNumbersId);
}
break;
case SystemDevNumbersDataModel.DataColumns.Description:
if (!string.IsNullOrEmpty(data.Description))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SystemDevNumbersDataModel.DataColumns.Description, data.Description);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemDevNumbersDataModel.DataColumns.Description);
}
break;
case SystemDevNumbersDataModel.DataColumns.RangeFrom:
if (data.RangeFrom != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SystemDevNumbersDataModel.DataColumns.RangeFrom, data.RangeFrom);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemDevNumbersDataModel.DataColumns.RangeFrom);
}
break;
case SystemDevNumbersDataModel.DataColumns.RangeTo:
if (data.RangeTo != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SystemDevNumbersDataModel.DataColumns.RangeTo, data.RangeTo);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemDevNumbersDataModel.DataColumns.RangeTo);
}
break;
case SystemDevNumbersDataModel.DataColumns.PersonId:
if (data.PersonId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SystemDevNumbersDataModel.DataColumns.PersonId, data.PersonId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemDevNumbersDataModel.DataColumns.PersonId);
}
break;
case SystemDevNumbersDataModel.DataColumns.Person:
if (!string.IsNullOrEmpty(data.Person))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SystemDevNumbersDataModel.DataColumns.Person, data.Person);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemDevNumbersDataModel.DataColumns.Person);
}
break;
case SystemDevNumbersDataModel.DataColumns.ApplicationUserId:
if (data.ApplicationUserId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SystemDevNumbersDataModel.DataColumns.ApplicationUserId, data.ApplicationUserId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemDevNumbersDataModel.DataColumns.ApplicationUserId);
}
break;
case SystemDevNumbersDataModel.DataColumns.ApplicationUser:
if (!string.IsNullOrEmpty(data.ApplicationUser))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SystemDevNumbersDataModel.DataColumns.ApplicationUser, data.ApplicationUser);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemDevNumbersDataModel.DataColumns.ApplicationUser);
}
break;
default:
returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static void Update(SystemDevNumbersDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
DBDML.RunSQL("SystemDevNumbers.Update", sql, DataStoreKey);
}
protected override void OnInit(EventArgs e)
{
try
{
var superKey = string.Empty;
var newId = SystemEntityTypeDataManager.GetNextSequence("Client", (int)SystemEntity.Client, SessionVariables.RequestProfile);
var clientData = new ClientDataModel();
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"];
var data = new SuperKeyDetailDataModel();
data.SuperKeyId = Convert.ToInt32(superKey);
data.SystemEntityTypeId = (int)SystemEntity.Client;
var dt = SuperKeyDetailDataManager.Search(data, SessionVariables.RequestProfile);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var key = (int)(dr[SuperKeyDetailDataModel.DataColumns.EntityKey]);
clientData.ClientId = key;
var clientdt = ClientDataManager.GetDetails(clientData, SessionVariables.RequestProfile);
if (clientdt.Rows.Count == 1)
{
var row = clientdt.Rows[0];
if (Request.QueryString["Mode"].Equals("Test"))
{
clientData.ClientId = GetNextValidId(rangefrom);
}
clientData.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]);
clientData.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]);
clientData.SortOrder = (int)(row[StandardDataModel.StandardDataColumns.SortOrder]);
ClientDataManager.Create(clientData, SessionVariables.RequestProfile);
}
}
}
}
else if (Request.QueryString["SetId"] != null)
{
var key = int.Parse(Request.QueryString["SetId"]);
clientData.ClientId = key;
var clientdt = ClientDataManager.GetDetails(clientData, SessionVariables.RequestProfile);
if (clientdt.Rows.Count == 1)
{
var row = clientdt.Rows[0];
var newclientdata = new ClientDataModel();
if (Request.QueryString["Mode"].Equals("Test"))
{
newclientdata.ClientId = newId = GetNextValidId(rangefrom);
}
newclientdata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]);
newclientdata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]);
newclientdata.SortOrder = (int)(row[StandardDataModel.StandardDataColumns.SortOrder]);
UpdatedFKDepenedencies(key, newId);
ClientDataManager.Delete(clientData, SessionVariables.RequestProfile);
ClientDataManager.Create(newclientdata, SessionVariables.RequestProfile);
}
}
else if (Request.QueryString["Mode"].Equals("Renumber"))
{
var seed = int.Parse(Request.QueryString["Seed"]);
//ApplicationVariables.Seed;
var increment = int.Parse(Request.QueryString["Increment"]);
//ApplicationVariables.Increment;
ClientDataManager.Renumber(seed, increment, SessionVariables.RequestProfile);
}
base.OnInit(e);
Response.Redirect(Page.GetRouteUrl("ClientEntityRoute", new { Action = "Default", SetId = true }), false);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
