public static List <ReleaseLogDetailDataModel> GetEntityDetails(ReleaseLogDetailDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.ReleaseLogDetailSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationId = requestProfile.ApplicationId
, ReleaseLogId = dataQuery.ReleaseLogId
, ReleaseLogDetailId = dataQuery.ReleaseLogDetailId
, Feature = dataQuery.Feature
, ModuleId = dataQuery.ModuleId
, ReleaseFeatureId = dataQuery.ReleaseFeatureId
, SystemEntityTypeId = dataQuery.SystemEntityTypeId
, PrimaryDeveloper = dataQuery.PrimaryDeveloper
, PrimaryEntity = dataQuery.PrimaryEntity
, ReleaseIssueTypeId = dataQuery.ReleaseIssueTypeId
, ReleasePublishCategoryId = dataQuery.ReleasePublishCategoryId
, JIRA = dataQuery.JIRA
, UpdatedDateRangeMin = dataQuery.UpdatedDateRangeMin
, UpdatedDateRangeMax = dataQuery.UpdatedDateRangeMax
, ReturnAuditInfo = returnAuditInfo
};
List <ReleaseLogDetailDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <ReleaseLogDetailDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public override int?Save(string action)
{
var data = new ReleaseLogDetailDataModel();
data.ReleaseLogDetailId = ReleaseLogDetailId;
data.ApplicationId = ApplicationId;
data.ItemNo = ItemNo;
data.Description = Description;
data.PrimaryDeveloper = PrimaryDeveloper;
data.SortOrder = SortOrder;
data.ReleaseIssueTypeId = ReleaseIssueTypeId;
data.ReleasePublishCategoryId = ReleasePublishCategoryId;
data.Feature = Feature;
data.ModuleId = ModuleId;
data.ReleaseFeatureId = ReleaseFeatureId;
data.JIRA = JIRA;
data.PrimaryEntity = PrimaryEntity;
data.ReleaseLogId = ReleaseLogId;
data.TimeSpent = TimeSpent;
data.SystemEntityTypeId = SystemEntityTypeId;
//if (drpNewApplicationIdList.Enabled == false)
if (drpNewApplicationIdList.SelectedItem.Value == "-1" || drpNewApplicationIdList.SelectedItem.Value == "100")
{
Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.Save(data, AuditId, action);
}
else
{
ReleaseNotesWorkFlow.MoveToApplication(ReleaseLogDetailId.Value, NewApplicationId.Value, AuditId);
}
// not correct ... when doing insert, we didn't get/change the value of ReleaseLogID ?
return(ReleaseLogDetailId);
}
public static DataTable GetDetails(ReleaseLogDetailDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile);
var table = list.ToDataTable();
return(table);
}
public static List <ReleaseLogDetailDataModel> GetList(string prefixText, RequestProfile requestProfile)
{
var data = new ReleaseLogDetailDataModel()
{
Feature = prefixText
};
return(GetEntityDetails(data, requestProfile, 0));
}
private DataTable GetReleaseLogDetailData(int ReleaseLogId)
{
var data = new ReleaseLogDetailDataModel();
data.ReleaseLogId = ReleaseLogId;
var dt = Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.Search(data, AuditId);
return(dt);
}
public void LoadData(int releaseLogDetailId, bool showId)
{
// clear UI
Clear();
// set up parameters
var data = new ReleaseLogDetailDataModel();
data.ReleaseLogDetailId = releaseLogDetailId;
// get data
var items = Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.GetEntityDetails(data, AuditId);
// should only have single match -- should log exception.
if (items.Count != 1)
{
return;
}
var item = items[0];
ReleaseLogDetailId = item.ReleaseLogDetailId;
ApplicationId = item.ApplicationId;
ItemNo = item.ItemNo;
Description = item.Description;
PrimaryDeveloper = item.PrimaryDeveloper;
SortOrder = item.SortOrder;
ReleaseIssueTypeId = item.ReleaseIssueTypeId;
ReleasePublishCategoryId = item.ReleasePublishCategoryId;
Feature = item.Feature;
ModuleId = item.ModuleId;
ReleaseFeatureId = item.ReleaseFeatureId;
JIRA = item.JIRA;
PrimaryEntity = item.PrimaryEntity;
ReleaseLogId = item.ReleaseLogId;
TimeSpent = item.TimeSpent;
SystemEntityTypeId = item.SystemEntityTypeId;
if (!showId)
{
txtReleaseLogDetailId.Text = item.ReleaseLogDetailId.ToString();
drpApplicationIdList.Enabled = false;
txtApplicationId.Enabled = false;
drpNewApplicationIdList.Enabled = true;
txtNewApplicationId.Enabled = true;
//PlaceHolderAuditHistory.Visible = true;
// only show Audit History in case of Update page, not for Clone.
oHistoryList.Setup(base.PrimaryEntity, releaseLogDetailId, PrimaryEntityKey);
}
else
{
txtReleaseLogDetailId.Text = String.Empty;
}
oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction);
}
private System.Data.DataTable GetData()
{
// TODO: on all export pages
var data = new ReleaseLogDetailDataModel();
var dt = Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.Search(data, AuditId);
return(dt);
}
public static bool DoesExist(ReleaseLogDetailDataModel data, RequestProfile requestProfile)
{
var doesExistRequest = new ReleaseLogDetailDataModel();
doesExistRequest.ReleaseLogDetailId = data.ReleaseLogDetailId;
var list = GetEntityDetails(doesExistRequest, requestProfile, 0);
return(list.Count > 0);
}
private DataTable GetData(string releaseLogDetailId)
{
var data = new ReleaseLogDetailDataModel();
data.ReleaseLogDetailId = int.Parse(releaseLogDetailId);
var dt = Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.Search(data, AuditId);
return(dt);
}
public static DataTable DoesExist(ReleaseLogDetailDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ReleaseLogDetailSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseLogDetailId);
var oDt = new DBDataTable("ReleaseLogDetail.DoesExist", sql, DataStoreKey);
return(oDt.DBTable);
}
public static DataTable GetParentReleaseLogDetailItemList(ReleaseLogDetailDataModel data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.ReleaseLogDetailSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId);
var oDt = new DBDataTable("ReleaseLogDetail.GetList", sql, DataStoreKey);
return(oDt.DBTable);
}
public static DataSet ReleaseNotesSearch(ReleaseLogDetailDataModel data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.ReleaseNotesSearch" +
" " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMax) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMin) +
SearchParameter(data, requestProfile);
var oDs = new DBDataSet("ReleaseLog.ReleaseNotesSearch", sql, DataStoreKey);
return(oDs.DBDataset);
}
public static DataTable Search(ReleaseLogDetailDataModel data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.ReleaseLogDetailSearch " +
" " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseLogDetailId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMax) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMin) +
SearchParameter(data, requestProfile);
var oDt = new DBDataTable("ReleaseLogDetail.Search", sql, DataStoreKey);
return(oDt.DBTable);
}
public static void Delete(ReleaseLogDetailDataModel data, RequestProfile requestProfile)
{
const string sql = @"dbo.ReleaseLogDetailDelete ";
var parameters = new
{
AuditId = requestProfile.AuditId
, ReleaseLogDetailId = data.ReleaseLogDetailId
};
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure);
}
}
// What that will do is take a ReleaseLogDetailID clone it and save it with different applicationID. And Delete the original RelaseLogDetail.
// Should debug if debug should be real if real.
public static void MoveToApplication(int releaseLogDetailId, int applicationId, RequestProfile requestProfile)
{
var dataItem = new ReleaseLogDetailDataModel();
dataItem.ReleaseLogDetailId = releaseLogDetailId;
var oDetail = ReleaseLogDetailDataManager.GetDetails(dataItem, requestProfile);
if (oDetail != null)
{
//copy data from old record
dataItem.ApplicationId = oDetail.ApplicationId;
dataItem.Application = oDetail.Application;
dataItem.ReleaseLog = oDetail.ReleaseLog;
dataItem.ReleaseLogId = oDetail.ReleaseLogId;
dataItem.ItemNo = oDetail.ItemNo;
dataItem.Description = oDetail.Description;
dataItem.RequestedBy = oDetail.RequestedBy;
dataItem.RequestedDate = oDetail.ReleaseDate;
dataItem.PrimaryDeveloper = oDetail.PrimaryDeveloper;
dataItem.SortOrder = oDetail.SortOrder;
dataItem.ReleaseIssueTypeId = oDetail.ReleaseIssueTypeId;
dataItem.ReleasePublishCategoryId = oDetail.ReleasePublishCategoryId;
dataItem.ReleaseIssueType = oDetail.ReleaseIssueType;
dataItem.ReleasePublishCategory = oDetail.ReleasePublishCategory;
dataItem.Feature = oDetail.Feature;
dataItem.Module = oDetail.Module;
dataItem.ModuleId = oDetail.ModuleId;
dataItem.JIRA = oDetail.JIRA;
dataItem.PrimaryEntity = oDetail.PrimaryEntity;
dataItem.TimeSpent = oDetail.TimeSpent;
//delete old record
ReleaseLogDetailDataManager.Delete(dataItem, requestProfile);
// change application id
dataItem.ApplicationId = applicationId;
// ReleaseLogDetailId will remain same, only ApplicationId will change
ReleaseLogDetailDataManager.Save(dataItem, requestProfile, "Insert");
}
}
protected void FillInnerRepeater()
{
var dtReleaseLog = Framework.Components.ReleaseLog.ReleaseLogDataManager.GetList(SessionVariables.RequestProfile);
for (var i = 0; i < dtReleaseLog.Rows.Count; i++)
{
var releaselogid = int.Parse(dtReleaseLog.Rows[i].ItemArray[0].ToString());
var data = new ReleaseLogDetailDataModel();
data.ReleaseLogId = releaselogid;
var dtreleaselogdetails = Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.GetDetails(data, SessionVariables.RequestProfile);
Repeater rptr = (Repeater)rptrReleaseLog.Items[i].FindControl("rptrReleaseLogDetails");
if (rptr != null)
{
rptr.DataSource = dtreleaselogdetails;
rptr.DataBind();
}
}
}
protected override void ShowData(int releaseLogDetailId)
{
base.ShowData(releaseLogDetailId);
oDetailButtonPanel.SetId = SetId;
Clear();
var data = new ReleaseLogDetailDataModel();
data.ReleaseLogDetailId = releaseLogDetailId;
var items = Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.GetEntityDetails(data, AuditId);
// should only have single match
if (items.Count == 1)
{
var item = items[0];
lblReleaseLogDetailId.Text = item.ReleaseLogDetailId.ToString();
lblReleaseLogId.Text = item.ReleaseLog;
lblApplicationId.Text = item.Application;
lblItemNo.Text = item.ItemNo.ToString();
lblDescription.Text = item.Description;
lblRequestedBy.Text = item.RequestedBy.ToString();
lblPrimaryDeveloper.Text = item.PrimaryDeveloper;
lblRequestedDate.Text = item.RequestedDate.Value.ToString(SessionVariables.UserDateFormat);
lblSortOrder.Text = item.SortOrder.ToString();
lblReleaseIssueType.Text = item.ReleaseIssueType;
lblReleasePublishCategory.Text = item.ReleasePublishCategory;
lblFeature.Text = item.Feature;
lblModule.Text = item.Module;
lblReleaseFeature.Text = item.ReleaseFeature;
lblJIRA.Text = item.JIRA;
lblPrimaryEntity.Text = item.PrimaryEntity;
lblSystemEntityType.Text = item.SystemEntityType;
lblTimeSpent.Text = item.TimeSpent.ToString();
oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction);
oHistoryList.Setup(PrimaryEntity, releaseLogDetailId, "ReleaseLogDetail");
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
string[] deleteIndexList = DeleteIds.Split(',');
foreach (string index in deleteIndexList)
{
var data = new ReleaseLogDetailDataModel();
data.ReleaseLogDetailId = int.Parse(index);
Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.Delete(data, SessionVariables.AuditId);
}
DeleteAndRedirect();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
private void InsertDetails()
{
var data = new ReleaseLogDetailDataModel();
var AuditId = SessionVariables.RequestProfile.AuditId;
data.ReleaseLogDetailId = int.Parse(txtReleaseLogDetailId.Text);
data.ReleaseLogId = int.Parse(txtReleaseLogId.Text);
data.ItemNo = int.Parse(txtItemNo.Text);
data.Description = txt_Description.Text;
data.SortOrder = int.Parse(txt_SortOrder.Text);
Framework.Components.ReleaseLog.ReleaseLogDetailDataManager.Save(data, SessionVariables.RequestProfile, "Insert");
lblMessage.Text = "Record Saved";
lblMessage.Visible = true;
txtReleaseLogDetailId.Text = String.Empty;
txtItemNo.Text = String.Empty;
txt_Description.Text = String.Empty;
txt_SortOrder.Text = String.Empty;
}
public static string SearchParameter(ReleaseLogDetailDataModel data, RequestProfile requestProfile)
{
var sql = ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseLogId) +
", " + ToSQLParameter(ReleaseLogDetailDataModel.DataColumns.ApplicationId, data.ApplicationId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.Feature) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ModuleId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseFeatureId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.Description) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.PrimaryEntity) +
//", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.SystemEntityTypeId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseIssueTypeId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.JIRA) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMin) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMax);
return(sql);
}
public static void Save(ReleaseLogDetailDataModel data, RequestProfile requestProfile, string action)
{
var sql = "EXEC ";
switch (action)
{
case "Insert":
data.RequestedBy = "Admin";
data.RequestedDate = DateTime.Now;
sql += "dbo.ReleaseLogDetailInsert " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ApplicationId);
break;
case "Update":
sql += "dbo.ReleaseLogDetailUpdate " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
break;
}
sql += ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseLogDetailId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseLogId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.Feature) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ModuleId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseFeatureId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.SystemEntityTypeId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.PrimaryEntity) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseIssueTypeId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.JIRA) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ItemNo) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.Description) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.SortOrder) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.RequestedDate) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.TimeSpent) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.RequestedBy);
DBDML.RunSQL("ReleaseLogDetail.Save", sql, DataStoreKey);
}
protected override void Clear()
{
base.Clear();
var data = new ReleaseLogDetailDataModel();
ReleaseLogDetailId = data.ReleaseLogDetailId;
ApplicationId = data.ApplicationId;
ItemNo = data.ItemNo;
Description = data.Description;
PrimaryDeveloper = data.PrimaryDeveloper;
SortOrder = data.SortOrder;
ReleaseIssueTypeId = data.ReleaseIssueTypeId;
ReleasePublishCategoryId = data.ReleasePublishCategoryId;
Feature = data.Feature;
ModuleId = data.ModuleId;
ReleaseFeatureId = data.ReleaseFeatureId;
JIRA = data.JIRA;
PrimaryEntity = data.PrimaryEntity;
ReleaseLogId = data.ReleaseLogId;
TimeSpent = data.TimeSpent;
SystemEntityTypeId = data.SystemEntityTypeId;
}
public ResultSet CalculateRNandSDWorkedHours(string emailAddress, int appId)
{
var rnTotalHours = 0.0;
var srnTotalHours = 0.0;
var sdTotalHours = 0;
var temp = 0.0;
var developer = string.Empty;
var appUserId = 0;
var appUserName = string.Empty;
var fromDateTime = new DateTime();
var toDateTime = new DateTime();
var date = new ReleaseLogDetailDataModel();
var dateValue = ReleaseLogDetailDataManager.GetDetails(date, SessionVariables.RequestProfile);
var dv = dateValue.DefaultView;
dv.Sort = "ReleaseDate ASC";
if (oDateRange.FromDateTime.Equals("") || oDateRange.ToDateTime.Equals(""))
{
fromDateTime = Convert.ToDateTime(dv.ToTable().Rows[0][ReleaseLogDetailDataModel.DataColumns.ReleaseDate].ToString());
toDateTime = Convert.ToDateTime(dv.ToTable().Rows[dateValue.Rows.Count - 1][ReleaseLogDetailDataModel.DataColumns.ReleaseDate].ToString());
}
else
{
fromDateTime = Convert.ToDateTime(DateTimeHelper.FromUserDateFormatToApplicationDateFormat(oDateRange.FromDateTime));
toDateTime = Convert.ToDateTime(DateTimeHelper.FromUserDateFormatToApplicationDateFormat(oDateRange.ToDateTime));
}
var format = SessionVariables.UserDateFormat;
var fromDate = fromDateTime.ToString(format);
var toDate = toDateTime.ToString(format);
//var appObj = new ApplicationDataModel();
//appObj.ApplicationId = appId;
//var dt3 = Framework.Components.ApplicationUser.ApplicationDataManager.Search(appObj, SessionVariables.RequestProfile);
//var applicationName = dt3.Rows[0][ApplicationDataModel.DataColumns.Name];
var obj1 = new ApplicationUserDataModel();
obj1.EmailAddress = emailAddress;
SessionVariables.RequestProfile.ApplicationId = 100;
var dt1 = ApplicationUserDataManager.Search(obj1, SessionVariables.RequestProfile);
//appUserId = (int)(dt1.Rows[0][ApplicationUserDataModel.DataColumns.ApplicationUserId]);
appUserName = dt1.Rows[0][ApplicationUserDataModel.DataColumns.FirstName] + " " + dt1.Rows[0][ApplicationUserDataModel.DataColumns.LastName];
if (dt1.Rows[0][ApplicationUserDataModel.DataColumns.LastName].ToString().Substring(1, 1).Equals("u"))
{
developer = (string)(dt1.Rows[0][ApplicationUserDataModel.DataColumns.FirstName].ToString().Substring(0, 1) + dt1.Rows[0][ApplicationUserDataModel.DataColumns.LastName].ToString().Substring(0, 1) + "2");
}
else
{
developer = (string)(dt1.Rows[0][ApplicationUserDataModel.DataColumns.FirstName].ToString().Substring(0, 1) + dt1.Rows[0][ApplicationUserDataModel.DataColumns.LastName].ToString().Substring(0, 1));
}
var tsObj = new ReleaseLogDetailDataModel();
tsObj.ReleaseDateMin = Convert.ToDateTime(fromDate);
tsObj.ReleaseDateMax = Convert.ToDateTime(toDate);
tsObj.ApplicationId = appId;
tsObj.PrimaryDeveloper = developer;
var dt4 = ReleaseLogDetailDataManager.Search(tsObj, SessionVariables.RequestProfile);
var temp1 = 0.0;
for (var i = 0; i < dt4.Rows.Count; i++)
{
if (dt4.Rows[i][ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper].Equals(developer) || dt4.Rows[i][ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper].Equals("Admin"))
{
if (!dt4.Rows[i][ReleaseLogDetailDataModel.DataColumns.TimeSpent].Equals("Unknown"))
{
temp1 = (double)Convert.ToDouble(dt4.Rows[i][ReleaseLogDetailDataModel.DataColumns.TimeSpent]);
srnTotalHours = srnTotalHours + temp1;
}
}
}
var sObj = new ApplicationUserDataModel();
sObj.EmailAddress = emailAddress;
sObj.ApplicationId = 100047;
var sDt = ApplicationUserDataManager.Search(sObj, SessionVariables.RequestProfile);
if (sDt.Rows.Count > 0)
{
var obj2 = new ScheduleDataModel();
obj2.FromSearchDate = Convert.ToDateTime(fromDate);
obj2.ToSearchDate = Convert.ToDateTime(toDate);
obj2.Person = (sDt.Rows[0][ApplicationUserDataModel.DataColumns.ApplicationUserId]).ToString();
obj2.ApplicationId = 100047;
//SessionVariables.RequestProfile.ApplicationId = 100047;
var dt2 = ScheduleDataManager.Search(obj2, SessionVariables.RequestProfile);
for (var i = 0; i < dt2.Rows.Count; i++)
{
temp = Convert.ToInt32(dt2.Rows[i][ScheduleDataModel.DataColumns.TotalHoursWorked]);
sdTotalHours = sdTotalHours + (int)temp;
}
}
var resultSet = new ResultSet(appUserName, ((int)(rnTotalHours + srnTotalHours)).ToString(), string.Format("{0}.00", sdTotalHours));
return(resultSet);
}
public static string ToSQLParameter(ReleaseLogDetailDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ReleaseLogDetailDataModel.DataColumns.ReleaseLogDetailId:
if (data.ReleaseLogDetailId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ReleaseLogDetailId, data.ReleaseLogDetailId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseLogDetailId);
}
break;
case ReleaseLogDetailDataModel.DataColumns.ApplicationId:
if (data.ApplicationId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ApplicationId, data.ApplicationId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ApplicationId);
}
break;
case ReleaseLogDetailDataModel.DataColumns.ModuleId:
if (data.ModuleId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ModuleId, data.ModuleId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ModuleId);
}
break;
case ReleaseLogDetailDataModel.DataColumns.ReleaseFeatureId:
if (data.ReleaseFeatureId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ReleaseFeatureId, data.ReleaseFeatureId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseFeatureId);
}
break;
case ReleaseLogDetailDataModel.DataColumns.SystemEntityTypeId:
if (data.SystemEntityTypeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.SystemEntityTypeId);
}
break;
case ReleaseLogDetailDataModel.DataColumns.ReleaseIssueTypeId:
if (data.ReleaseIssueTypeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ReleaseIssueTypeId, data.ReleaseIssueTypeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseIssueTypeId);
}
break;
case ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId:
if (data.ReleasePublishCategoryId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId, data.ReleasePublishCategoryId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId);
}
break;
case ReleaseLogDetailDataModel.DataColumns.ReleaseLogId:
if (data.ReleaseLogId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ReleaseLogId, data.ReleaseLogId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseLogId);
}
break;
case ReleaseLogDetailDataModel.DataColumns.ItemNo:
if (data.ItemNo != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.ItemNo, data.ItemNo);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ItemNo);
}
break;
case ReleaseLogDetailDataModel.DataColumns.SortOrder:
if (data.SortOrder != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogDetailDataModel.DataColumns.SortOrder, data.SortOrder);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.SortOrder);
}
break;
case ReleaseLogDetailDataModel.DataColumns.RequestedDate:
if (data.RequestedDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.RequestedDate, data.RequestedDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.RequestedDate);
}
break;
case ReleaseLogDetailDataModel.DataColumns.ReleaseDateMax:
if (data.ReleaseDateMax != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMax, data.ReleaseDateMax);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMax);
}
break;
case ReleaseLogDetailDataModel.DataColumns.ReleaseDateMin:
if (data.ReleaseDateMin != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMin, data.ReleaseDateMin);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMin);
}
break;
case ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMin:
if (data.UpdatedDateRangeMin != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMin, data.UpdatedDateRangeMin);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMin);
}
break;
case ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMax:
if (data.UpdatedDateRangeMax != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMax, data.UpdatedDateRangeMax);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.UpdatedDateRangeMax);
}
break;
case ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper:
if (!string.IsNullOrEmpty(data.PrimaryDeveloper))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper, data.PrimaryDeveloper.Trim());
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.PrimaryDeveloper);
}
break;
case ReleaseLogDetailDataModel.DataColumns.PrimaryEntity:
if (!string.IsNullOrEmpty(data.PrimaryEntity))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.PrimaryEntity, data.PrimaryEntity);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.PrimaryEntity);
}
break;
case ReleaseLogDetailDataModel.DataColumns.SystemEntityType:
if (!string.IsNullOrEmpty(data.SystemEntityType))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.SystemEntityType, data.SystemEntityType);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.SystemEntityType);
}
break;
case ReleaseLogDetailDataModel.DataColumns.JIRA:
if (!string.IsNullOrEmpty(data.JIRA))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.JIRA, data.JIRA);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.JIRA);
}
break;
case ReleaseLogDetailDataModel.DataColumns.Feature:
if (!string.IsNullOrEmpty(data.Feature))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.Feature, data.Feature);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.Feature);
}
break;
case ReleaseLogDetailDataModel.DataColumns.Module:
if (!string.IsNullOrEmpty(data.Module))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.Module, data.Module);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.Module);
}
break;
case ReleaseLogDetailDataModel.DataColumns.ReleaseFeature:
if (!string.IsNullOrEmpty(data.ReleaseFeature))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.ReleaseFeature, data.ReleaseFeature);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.ReleaseFeature);
}
break;
case ReleaseLogDetailDataModel.DataColumns.Description:
if (!string.IsNullOrEmpty(data.Description))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.Description, data.Description);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.Description);
}
break;
case ReleaseLogDetailDataModel.DataColumns.TimeSpent:
if (!string.IsNullOrEmpty(data.TimeSpent))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.TimeSpent, data.TimeSpent);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.TimeSpent);
}
break;
case ReleaseLogDetailDataModel.DataColumns.RequestedBy:
if (!string.IsNullOrEmpty(data.RequestedBy))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseLogDetailDataModel.DataColumns.RequestedBy, data.RequestedBy);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogDetailDataModel.DataColumns.RequestedBy);
}
break;
}
return(returnValue);
}
public static ReleaseLogDetailDataModel GetDetails(ReleaseLogDetailDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 1);
return(list.FirstOrDefault());
}
public static List <ReleaseLogDetailDataModel> GetParentReleaseLogDetailItemList(ReleaseLogDetailDataModel data, RequestProfile requestProfile)
{
return(GetEntityDetails(data, requestProfile, 0));
// formulate SQL
//var sql = "EXEC dbo.ReleaseLogDetailSearch " +
// " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
// ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
// ", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleasePublishCategoryId);
//var oDt = new DBDataTable("ReleaseLogDetail.GetList", sql, DataStoreKey);
//return oDt.DBTable;
}
