static public List <DBComponentNameDataModel> GetEntitySearch(DBComponentNameDataModel obj, RequestProfile requestProfile)
{
var dt = Search(obj, requestProfile);//SessionVariables.ApplicationMode);
var list = ToList(dt);
return(list);
}
public static List <TaskTypeDataModel> GetTaskTypeList(RequestProfile requestProfile)
{
return(GetEntityDetails(TaskTypeDataModel.Empty, requestProfile, 0));
}
public static void Update(DateRangeTitleDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("DateRangeTitle.Update", sql, DataStoreKey);
}
public static List <TabParentStructureDataModel> GetList(RequestProfile requestProfile)
{
return(GetEntityDetails(TabParentStructureDataModel.Empty, requestProfile, 0));
}
public static List <TaskXDeliverableArtifactDataModel> GetEntityDetails(TaskXDeliverableArtifactDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.TaskXDeliverableArtifactSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId);
var result = new List <TaskXDeliverableArtifactDataModel>();
using (var reader = new DBDataReader("Get Details", sql, DataStoreKey))
{
var dbReader = reader.DBReader;
while (dbReader.Read())
{
var dataItem = new TaskXDeliverableArtifactDataModel();
dataItem.TaskXDeliverableArtifactId = (int)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId];
dataItem.TaskId = (int)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.TaskId];
dataItem.DeliverableArtifactId = (int)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId];
dataItem.DeliverableArtifactStatusId = (int)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId];
dataItem.Task = (string)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.Task];
dataItem.DeliverableArtifact = (string)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifact];
dataItem.DeliverableArtifactStatus = (string)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatus];
SetBaseInfo(dataItem, dbReader);
result.Add(dataItem);
}
}
return(result);
}
public static List <PaymentMethodDataModel> GetList(RequestProfile requestProfile)
{
return(GetEntityDetails(PaymentMethodDataModel.Empty, requestProfile, 0));
}
public static void Update(PaymentMethodDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("PaymentMethod.Update", sql, DataStoreKey);
}
public static void Update(NotificationPublisherXEventTypeDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
Framework.Components.DataAccess.DBDML.RunSQL("NotificationPublisherXEventType.Update", sql, DataStoreKey);
}
public static void Delete(NotificationPublisherXEventTypeDataModel dataQuery, RequestProfile requestProfile)
{
const string sql = @"dbo.NotificationPublisherXEventTypeDelete ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, NotificationPublisherXEventTypeId = dataQuery.NotificationPublisherXEventTypeId
, NotificationPublisherId = dataQuery.NotificationPublisherId
, NotificatiionEventTypeId = dataQuery.NotificationEventTypeId
};
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure);
}
}
public static DataTable GetByNotificationPublisher(int NotificationPublisherId, RequestProfile requestProfile)
{
var sql = "EXEC NotificationPublisherXEventTypeSearch @NotificationPublisherId =" + NotificationPublisherId + ", " +
"@AuditId=" + requestProfile.AuditId + ", " +
"@ApplicationId=" + requestProfile.ApplicationId;
var oDT = new Framework.Components.DataAccess.DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static List <NotificationPublisherXEventTypeDataModel> GetEntityList(NotificationPublisherXEventTypeDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.NotificationPublisherXEventTypeSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationId = requestProfile.ApplicationId
, NotificationPublisherXEventTypeId = dataQuery.NotificationPublisherXEventTypeId
, ReturnAuditInfo = returnAuditInfo
, ApplicationMode = requestProfile.ApplicationModeId
, NotificationPublisherId = dataQuery.NotificationPublisherId
, NotificationEventTypeId = dataQuery.NotificationEventTypeId
, CreatedDateId = dataQuery.CreatedDateId
, CreatedTimeId = dataQuery.CreatedTimeId
};
List <NotificationPublisherXEventTypeDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <NotificationPublisherXEventTypeDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public static void CreateByNotificationPublisher(int NotificationPublisherId, int[] notificationEventTypeIds, RequestProfile requestProfile)
{
foreach (int notificationEventTypeId in notificationEventTypeIds)
{
var sql = "EXEC NotificationPublisherXEventTypeInsert " +
"@NotificationEventTypeId=" + notificationEventTypeId + ", " +
"@NotificationPublisherId=" + NotificationPublisherId + ", " +
"@ApplicationId=" + requestProfile.ApplicationId + ", " +
"@AuditId=" + requestProfile.AuditId;
Framework.Components.DataAccess.DBDML.RunSQL("NotificationPublisherXEventTypeInsert", sql, DataStoreKey);
}
}
public static void Create(TabChildStructureDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Create");
DBDML.RunSQL("TabChildStructure.Insert", sql, DataStoreKey);
}
public static List <DeliverableArtifactStatusDataModel> GetDeliverableArtifactStatusList(RequestProfile requestProfile)
{
return(GetEntityDetails(DeliverableArtifactStatusDataModel.Empty, requestProfile, 0));
}
public static DataTable Search(ApplicationModeDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 0);
return(list.ToDataTable());
}
public static DataTable Search(NotificationPublisherXEventTypeDataModel data, RequestProfile requestProfile)
{
var list = GetEntityList(data, requestProfile, 0);
var table = list.ToDataTable();
return(table);
}
public void FormatMail(DataTable dt1, string mailFormat, string toEmailAddress, string ccEmailAddress, string fromEmailAddress,
bool isPreview, RequestProfile requestProfile)
{
var mailTemplate = mailFormat;
decimal totalhrs = 0;
var stringBuilder = new StringBuilder();
var strSubject = new StringBuilder();
var scheduleDetailData = (from m in dt1.AsEnumerable()
select new
{
InTime = m["InTime"],
OutTime = m["OutTime"],
Message = m["Message"].ToString(),
ScheduleDetailActivityCategory = m["ScheduleDetailActivityCategory"].ToString(),
ScheduleDetailActivityCategoryId = m["ScheduleDetailActivityCategoryId"],
WorkDate = m["WorkDate"],
DateDiffHrs = m["DateDiffHrs"],
Person = m["Person"],
PersonId = m["PersonId"],
EmailAddress = m["EmailAddress"],
ScheduleId = m["ScheduleId"],
WorkTicket = m["WorkTicket"]
}).OrderBy(m => m.InTime).ToList();
var workDate_distinct = (from c in dt1.AsEnumerable()
select new
{
WorkDate = c["WorkDate"].ToString(),
Person = c["Person"],
ScheduleId = c["ScheduleId"]
}).Distinct();
if (!string.IsNullOrEmpty(mailTemplate))
{
foreach (var c in workDate_distinct)
{
mailTemplate = mailTemplate.Replace("##PersonName##", c.Person.ToString());
mailTemplate = mailTemplate.Replace("##WorkDate##", Convert.ToDateTime(c.WorkDate).ToString("MMMM dd, yyyy"));
}
foreach (var item in scheduleDetailData)
{
if (item.DateDiffHrs != null)
{
totalhrs = totalhrs + Convert.ToDecimal(item.DateDiffHrs);
}
}
mailTemplate = mailTemplate.Replace("##StartTime##", Convert.ToDateTime(scheduleDetailData.Select(grp => grp.InTime).First()).ToShortTimeString());
mailTemplate = mailTemplate.Replace("##EndTime##", Convert.ToDateTime(scheduleDetailData.Select(grp => grp.OutTime).Last()).ToShortTimeString());
mailTemplate = mailTemplate.Replace("##TotalHrs##", totalhrs.ToString("0.00"));
var bColor = "#d9edf7";
var i = 0;
foreach (var item in scheduleDetailData)
{
var jiraIssue = JiraDataManager.GetDetails(item.WorkTicket.ToString());
var jiraDescription = "N/A";
var jiraPriority = "N/A";
var jiraWorkHours = GetJiraWorkHours(item.WorkTicket.ToString(), Convert.ToDateTime(item.WorkDate), Convert.ToInt32(item.PersonId));
personId = Convert.ToInt32(item.PersonId);
var minsDuration = ScheduleDataManager.GetMinutes(Convert.ToDouble(item.DateDiffHrs));
var jiraURL = "http://*****:*****@indusvalleyresearch.com";
}
var nMail = new MailMessage(fromEmailAddress, strToEmail);
//string strFromEmail = "*****@*****.**";
if (ccEmailAddress != string.Empty)
{
MailAddress copy = new MailAddress(ccEmailAddress);
nMail.CC.Add(copy);
}
foreach (var item in scheduleDetailData)
{
string bccMail = item.EmailAddress.ToString();
if (bccMail != string.Empty)
{
nMail.Bcc.Add(new MailAddress(bccMail));
}
}
foreach (var c in workDate_distinct)
{
strSubject.Append("EOD Daily Summary Email for " + Convert.ToDateTime(c.WorkDate).ToString("MMMM dd, yyyy") + "(" + totalhrs.ToString("0.00") + " hrs" + ")");
strSubject.Append(" - Sent on behalf of " + c.Person);
}
nMail.Subject = strSubject.ToString();
nMail.Body = mailTemplate;
nMail.IsBodyHtml = true;
var a = new SmtpClient();
a.Send(nMail);
}
}
public static DataTable DoesExist(NotificationPublisherXEventTypeDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.NotificationPublisherXEventTypeSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, NotificationPublisherXEventTypeDataModel.DataColumns.NotificationPublisherXEventTypeId);
var oDT = new Framework.Components.DataAccess.DBDataTable("NotificationPublisherXEventType.DoesExist", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable Search(PaymentMethodDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 0);
return(list.ToDataTable());
}
public static void DeleteByNotificationEventType(int notificationEventTypeId, RequestProfile requestProfile)
{
var sql = "EXEC NotificationPublisherXEventTypeDelete @NotificationEventTypeId =" + notificationEventTypeId + ", " +
ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", " +
"@AuditId ="+ requestProfile.AuditId;
Framework.Components.DataAccess.DBDML.RunSQL("Delete Details", sql, DataStoreKey);
}
public static void Update(TabParentStructureDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Update");
DBDML.RunSQL("TabParentStructure.Update", sql, DataStoreKey);
}
// 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");
}
}
public static TabParentStructureDataModel GetDetails(TabParentStructureDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 1);
return(list.FirstOrDefault());
}
public static ApplicationModeDataModel GetDetails(ApplicationModeDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 1);
return(list.FirstOrDefault());
}
public static void Update(TaskXDeliverableArtifactDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
DBDML.RunSQL("TaskXDeliverableArtifact.Update", sql, DataStoreKey);
}
public static void Update(ApplicationModeDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("ApplicationMode.Update", sql, DataStoreKey);
}
public static DateRangeTitleDataModel GetDetails(DateRangeTitleDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 1);
return(list.FirstOrDefault());
}
public static List <ApplicationModeDataModel> GetList(RequestProfile requestProfile)
{
return(GetEntityDetails(ApplicationModeDataModel.Empty, requestProfile, 0));
}
public static List <DateRangeTitleDataModel> GetEntityDetails(DateRangeTitleDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.DateRangeTitleSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationId = requestProfile.ApplicationId
, ApplicationMode = requestProfile.ApplicationModeId
, ReturnAuditInfo = returnAuditInfo
, DateRangeTitleId = dataQuery.DateRangeTitleId
, Name = dataQuery.Name
};
List <DateRangeTitleDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <DateRangeTitleDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public static List <ProvinceDataModel> GetList(RequestProfile requestProfile)
{
return(GetEntityDetails(ProvinceDataModel.Empty, requestProfile, 0));
}
