public void Execute(IJobExecutionContext context)
{
string dayofweek = DateTime.Now.DayOfWeek.ToString();
if (dayofweek != "Sunday" || dayofweek != "Saturday")
{
UserBLL users = new UserBLL();
var us = users.GetallUsers(); //lấy tất cả user
foreach (var item in us)
{
item.Checkmail = false; // trang thái về chưa gửi
users.Updatecheckmail(item, 0); // update trang thái người dùng thành chưa gửi
string ma = "" + item.IdUser;
string date = "" + DateTime.Now.Date;
string codema = Encrypt.sha1(ma); //mã hóa id
string codedate = Encrypt.sha1(date); // mã hóa date
//thêm content cho message
string content = "<p> Xin chào " + item.FullName + "</p><p> Bạn thấy ngày hôm này như thế nào? </p><p> Vui lòng chọn 1 loại cảm xúc </p>";
var st = new StatusBLL().Getall();
foreach (var i in st)
{
content += "<a href = \"http://pcmarket.somee.com/ReciveEmail/" + codema + "/" + i.IdStatus + "/" + codedate + "\">" + i.Name + "</a><br />";
}
//thêm message
MailMessage mes = setupmessage(content, "Hello", item.Email);
var client = setupclient();
sendmail(client, mes); // gọi hàm send
}
}
}
public ActionResult Dash()
{
DateTime date;
date = Convert.ToDateTime((Convert.ToDateTime(TempData["date"])).ToString("yyyy-MM-dd"));
Guid IdG = Guid.Parse(TempData["IdG"].ToString());
var list = new List <ChartData>();
HistoryBLL hs = new HistoryBLL();
var list1 = hs.Checkdate(date, IdG);
foreach (var item in list1)
{
ChartData cd = new ChartData();
cd.amount = item.Amount;
StatusBLL st = new StatusBLL();
cd.name = (st.Getname(item.IdStatus));
list.Add(cd);
}
List <int?> am = new List <int?>();
List <string> nm = new List <string>();
foreach (var item in list)
{
am.Add(item.amount);
nm.Add(item.name);
}
var rep = am;
ViewBag.AMOUNT = am;
ViewBag.NAME = nm;
return(View());
}
public void Dispose()
{
ApplicationBLL = null;
CustomerBLL = null;
CaseBLL = null;
CollectionBLL = null;
StatusBLL = null;
}
public ApplicationManager()
{
ApplicationBLL = new ApplicationBLL();
CustomerBLL = new CustomerBLL();
CaseBLL = new CaseBLL();
CollectionBLL = new CollectionBLL();
StatusBLL = new StatusBLL();
}
public ICase Create(string appId, string type, string text)
{
IStatus status = StatusBLL.Get(appId);
status = status == null
? StatusBLL.Create(appId, JobStatus.HasCase.ToLabel())
: StatusBLL.Update(status, JobStatus.HasCase.ToLabel());
return(CaseBLL.Create(appId, type, text));
}
public void CreateTask(TaskBLL task, string authorName, string assigneeName)
{
if (string.IsNullOrWhiteSpace(authorName))
{
throw new ArgumentNullException("Author is not shown", "authorName");
}
PersonBLL authorBLL = mapper.Map <Person, PersonBLL>(db.People.Find(p => p.Name == authorName).Single());
PersonBLL assigneeBLL;
if (string.IsNullOrEmpty(assigneeName))
{
assigneeBLL = authorBLL;
}
else
{
assigneeBLL = mapper.Map <Person, PersonBLL>(db.People.Find(p => p.Name == assigneeName).Single());
}
StatusBLL status = mapper.Map <Status, StatusBLL>(db.Statuses.Find(s => (s.Name == "New")).SingleOrDefault());
if (status == null)
{
throw new Exception("Status \"New\" wasn't found in database");
}
var newTask = new TaskBLL
{
ParentId = null,
Author = authorBLL,
Name = task.Name,
Assignee = assigneeBLL,
Status = status,
Progress = 0,
DateStart = null,
ETA = task.ETA,
DueDate = task.DueDate,
Comment = task.Comment
};
db.Tasks.Create(mapper.Map <TaskBLL, _Task>(newTask));
db.Save();
}
public CaseManager()
{
_caseBLL = new CaseBLL();
_applicationBLL = new ApplicationBLL();
StatusBLL = new StatusBLL();
}
protected void Page_Load(object sender, EventArgs e)
{
SiteSession session = SiteSessionFactory.LoadSession(this.Page);
session.Errors.Clear();
SiteSessionFactory.SaveSession(this.Page, session);
if (!session.LoginAccepted)
{
Response.Redirect("~/Denied.aspx");
}
else
{
if (session.Data.ContainsKey("call"))
{
session.Data.Remove("call");
}
if (session.Data.ContainsKey("part"))
{
session.Data.Remove("part");
}
if (session.Data.ContainsKey("search"))
{
session.Data.Remove("search");
}
if (session.Data.ContainsKey("basket"))
{
session.Data.Remove("basket");
}
callsBLL = new CallsBLL();
try
{
if (!Page.IsCallback)
{
GridView1.Columns[4].Visible = session.Device == "DESKTOP";
GridView1.Columns[2].Visible = session.Device == "DESKTOP";
GridView1.Columns[4].Visible = session.Login.OSPRef == "SONY3C";
GridView1.Columns[5].Visible = session.Login.OSPRef == "SONY3C";
// Test - Peter
// if (session.Params["type"] == "closed" ||
// session.Params["type"] == "wip" ||
// session.Params["type"] == "nodate" ||
// session.Params["type"] == "new" ||
// session.Params["type"] == "incomplete" ||
// session.Params["type"] == "parts")
// session.Params["type"] == "search")
// {
// Peter Test ----------------------------
CallDataSource.EnablePaging = true;
CallDataSource.SelectParameters.Clear();
CallDataSource.StartRowIndexParameterName = "startRowIndex";
CallDataSource.MaximumRowsParameterName = "maxNumRows";
CallDataSource.SelectParameters.Add(new Parameter("saediId"));
if (Request.QueryString["ID"] != null)
{
if (Request.QueryString["ID"].Length > 3)
{
Response.RedirectPermanent("~/Home.aspx");
}
StatusBLL statusBLL = new StatusBLL();
try
{
int statusID = int.Parse(Request.QueryString["ID"].ToString());
string statusName = statusBLL.GetStatusName(statusID);
titleLabel.Text = " - " + statusName;
}
catch
{
Response.RedirectPermanent("~/Home.aspx");
}
dateLabel.Visible = false;
previousButton.Visible = false;
nextButton.Visible = false;
todayButton.Visible = false;
calendarButton.Visible = false;
CallDataSource.SelectParameters.Add(new Parameter("statusId"));
session.Params.Remove("Chart-StatusID");
CallDataSource.SelectMethod = "GetCallsByStatus";
CallDataSource.SelectCountMethod = "GetCallsByStatusCount";
return;
}
if (Request.QueryString["callId"] != null)
{
CallDataSource.SelectParameters.Add(new Parameter("callId"));
titleLabel.Text = " - Search Results";
// Test Peter: ---------------------------------
CallDataSource.SelectMethod = "GetModelsBySearch";
CallDataSource.SelectCountMethod = "GetModelsBySearchCount";
// ---------------------------------------------
dateLabel.Visible = false;
previousButton.Visible = false;
nextButton.Visible = false;
todayButton.Visible = false;
calendarButton.Visible = false;
return;
}
if (session.Params["type"] == "search")
{
CallDataSource.SelectParameters.Add(new Parameter("callId"));
CallDataSource.SelectParameters.Add(new Parameter("postCode"));
CallDataSource.SelectParameters.Add(new Parameter("surname"));
CallDataSource.SelectParameters.Add(new Parameter("status"));
CallDataSource.SelectParameters.Add(new Parameter("importedTechnicianCD"));
CallDataSource.SelectParameters.Add(new Parameter("dateFrom"));
CallDataSource.SelectParameters.Add(new Parameter("dateTo"));
CallDataSource.SelectParameters.Add(new Parameter("CaseId"));
}
if (session.Params["type"] == "Reservationsearch")
{
CallDataSource.SelectParameters.Add(new Parameter("ReservationId"));
}
// }
// ----------------------------------------
if (session.Params["type"] == "date")
{
DateTime saved = DateTime.Parse(session.Params["date"]);
titleLabel.Text = " - Date";
dateLabel.Text = saved.ToString("d");
dateLabel.Visible = true;
previousButton.Visible = true;
nextButton.Visible = true;
todayButton.Visible = true;
calendarButton.Visible = true;
CallDataSource.SelectParameters.Add(new Parameter("thedate"));
// Test Peter: ---------------------------------
CallDataSource.SelectMethod = "GetModelsByDate";
CallDataSource.SelectCountMethod = "GetModelsByDateCount";
// ---------------------------------------------
// callsBLL.List = callsBLL.GetModelsByDate(session.Login.SaediId, DateTime.Parse(session.Params["date"]));
}
else
{
dateLabel.Visible = false;
previousButton.Visible = false;
nextButton.Visible = false;
todayButton.Visible = false;
calendarButton.Visible = false;
if (session.Params["type"] == "new")
{
titleLabel.Text = " - New Calls";
GridView1.Columns[4].Visible = false;
// Test Peter: ---------------------------------
CallDataSource.SelectMethod = "GetModelsNewCalls";
CallDataSource.SelectCountMethod = "GetModelsNewCallsCount";
// ---------------------------------------------
// callsBLL.List = callsBLL.GetModelsNewCalls(session.Login.SaediId);
}
else if (session.Params["type"] == "nodate")
{
titleLabel.Text = " - No Date";
// Test Peter: ---------------------------------
CallDataSource.SelectMethod = "GetModelsNoDate";
CallDataSource.SelectCountMethod = "GetModelsNoDateCount";
// ---------------------------------------------
// callsBLL.List = callsBLL.GetModelsNoDate(session.Login.SaediId);
}
else if (session.Params["type"] == "incomplete")
{
titleLabel.Text = " - Visit Booked";
// Test Peter: ---------------------------------
CallDataSource.SelectMethod = "GetModelsIncomplete";
CallDataSource.SelectCountMethod = "GetModelsIncompleteCount";
// ---------------------------------------------
// callsBLL.List = callsBLL.GetModelsIncomplete(session.Login.SaediId);
}
else if (session.Params["type"] == "parts")
{
titleLabel.Text = " - Parts Required";
// Test Peter: ---------------------------------
CallDataSource.SelectMethod = "GetModelsRequiresOrder";
CallDataSource.SelectCountMethod = "GetModelsRequiresOrderCount";
// ---------------------------------------------
// callsBLL.List = callsBLL.GetModelsRequiresOrder(session.Login.SaediId);
}
else if (session.Params["type"] == "wip")
{
titleLabel.Text = " - Work in Progress";
// Test Peter: ---------------------------------
CallDataSource.SelectMethod = "GetModelsAllWIP";
CallDataSource.SelectCountMethod = "GetModelsAllWIPCount";
// ---------------------------------------------
// callsBLL.List = callsBLL.GetModelsAllWIP(session.Login.SaediId);
}
else if (session.Params["type"] == "RMAcollect")
{
titleLabel.Text = " - RMA collection";
// Test Peter: ---------------------------------
CallDataSource.SelectMethod = "GetModelsRMACollection";
CallDataSource.SelectCountMethod = "GetModelsRMACollectionCount";
// ---------------------------------------------
// Test Peter: ---------------------------------
// callsBLL.List = callsBLL.GetModelsAllClosed(session.Login.SaediId);
}
else if (session.Params["type"] == "S2CList")
{
titleLabel.Text = " - Swap to credit";
// Test Peter: ---------------------------------
CallDataSource.SelectMethod = "GetModelsS2C";
CallDataSource.SelectCountMethod = "GetModelsS2Ccount";
// ---------------------------------------------
// Test Peter: ---------------------------------
// callsBLL.List = callsBLL.GetModelsAllClosed(session.Login.SaediId);
}
else if (session.Params["type"] == "closed")
{
titleLabel.Text = " - Closed";
// Test Peter: ---------------------------------
CallDataSource.SelectMethod = "GetModelsAllClosed";
CallDataSource.SelectCountMethod = "GetModelsAllClosedCount";
// ---------------------------------------------
// Test Peter: ---------------------------------
// callsBLL.List = callsBLL.GetModelsAllClosed(session.Login.SaediId);
}
else if (session.Params["type"] == "search" && session.Params["status"] == "1")
{
titleLabel.Text = " - Search for New";
// Test Peter: ---------------------------------
CallDataSource.SelectMethod = "GetModelsBySearch";
CallDataSource.SelectCountMethod = "GetModelsBySearchCount";
// ---------------------------------------------
// callsBLL.List = callsBLL.GetModelsBySearch(session.Login.SaediId, session.Params["callId"], session.Params["postCode"], session.Params["surname"], session.Params["status"]);
}
else if (session.Params["type"] == "Reservationsearch")
{
// CallDataSource.SelectParameters.Add(new Parameter("ReservationId"));
CallDataSource.SelectMethod = "GetModelsByReservationsearch";
CallDataSource.SelectCountMethod = "GetModelsByReservationsearchCount";
}
else if (session.Params["type"] == "search")
{
titleLabel.Text = " - Search Results";
// Test Peter: ---------------------------------
CallDataSource.SelectMethod = "GetModelsBySearch";
CallDataSource.SelectCountMethod = "GetModelsBySearchCount";
// ---------------------------------------------
// callsBLL.List = callsBLL.GetModelsBySearch(session.Login.SaediId, session.Params["callId"], session.Params["postCode"], session.Params["surname"], session.Params["status"]);
}
else
{
titleLabel.Text = "Service Calls";
// Test Peter: ---------------------------------
CallDataSource.SelectMethod = "GetModelsAllWIP";
CallDataSource.SelectCountMethod = "GetModelsAllWIPCount";
// ---------------------------------------------
// callsBLL.List = callsBLL.GetModelsAllWIP(session.Login.SaediId);
}
}
}
}
catch (Exception ex)
{ ex.ToString(); }
}
}
public void Dispose()
{
StatusBLL = null;
}
public StatusManager()
{
StatusBLL = new StatusBLL();
}
