protected void Page_Load(object sender, EventArgs e)
{
title = " abc";
Jobs jobHandle = new Jobs();
if (Request.QueryString["daysearch"] != null)
{
string daytam = Request.QueryString["daysearch"];
if (Request.QueryString["daysearch"] == "")
{
dbcon.Setdayfilter(daySelected);
}
else
{
dbcon.Setdayfilter(Request.QueryString["daysearch"]);
}
}
title = convetday(dbcon.Getcurrentday());
//Response.Write("<script>alert('" + title + "');</script>");
//title = GetDayStartOfWeek(daySelected);
if (Request.QueryString["iddelete"] != null)
{
jobHandle.job_id = int.Parse(Request.QueryString["iddelete"]);
jobHandle.Delete();
//ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "Thông báo: ", "<script>alert('Xóa công việc thành công');window.location='index.aspx';</script>");
Response.Write("<script>alert('Xóa công việc thành công');window.location='index.aspx';</script>");
}
if (Request.QueryString["idupdate"] != null)
{
jobHandle.job_id = int.Parse(Request.QueryString["idupdate"]);
jobHandle.job_title = Request.QueryString["textupdate"];
jobHandle.Update();
Response.Write("<script>alert('Cập nhật công việc thành công');window.location='index.aspx';</script>");
}
if (Request.QueryString["namecontact"] != null)
{
int idnv = int.Parse(Request.QueryString["namecontact"]);
jobHandle.job_id = int.Parse(Request.QueryString["namecontact_idjob"]);
jobHandle.DeleteOneContact(idnv);
Response.Write("<script>alert('Xóa cộng tác thành công');window.location='index.aspx';</script>");
}
if (Request.QueryString["contact"] != null)
{
jobHandle.job_id = int.Parse(Request.QueryString["idjob"]);
if (jobHandle.AddContact(Request.QueryString["contact"].Trim()))
{
Response.Write("<script>alert('Thêm cộng tác thành công');window.location='index.aspx';</script>");
}
else
{
Response.Write("<script>alert('[!] Không thể thêm cộng tác.!!');window.location='index.aspx';</script>");
}
}
if (Request.QueryString["job"] != null)
{
// title+= Request.QueryString["job"] +":"+ Request.QueryString["day"]+";";
string day = Request.QueryString["day"];
if (Request.QueryString["day"] == "")
{
day = DateTime.Now.ToString();
}
DateTime curday = new DateTime();
if (DateTime.Parse(dbcon.Getcurrentday()) >= DateTime.Now.AddDays(-1))
{
foreach (DateTime dayloop in EachDay(DateTime.Parse(GetDayStartOfWeek(dbcon.Getcurrentday())), DateTime.Parse(GetDayStartOfWeek(dbcon.Getcurrentday())).AddDays(6)))
{
curday = dayloop;
if (dayloop.DayOfWeek.ToString().Equals("Sunday"))
{
continue;
}
if (dayloop.DayOfWeek.ToString().Equals(day))
{
break;
}
}
if (!curday.DayOfWeek.ToString().Equals(day))
{
//ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "Cảnh báo: ", "<script>alert('Không thể thêm công việc cho quá khứ !!!');window.location='index.aspx';</script>");
Response.Write("<script>alert('Không thể thêm công việc cho quá khứ !!!');window.location='index.aspx';</script>");
}
else
{
jobHandle.job_id = jobHandle.CreateIdJobNext();
jobHandle.job_title = Request.QueryString["job"].Trim();
jobHandle.job_datestart = curday;
jobHandle.Insert((int)Session["User_ID"]);
Response.Write("<script>alert('Thêm công việc thành công');window.location='index.aspx';</script>");
}
}
else
{
Response.Write("<script>alert('Không thể thêm công việc cho quá khứ !!!');</script>");
}
//Response.Write("<script>alert('"+curday+ "');alert('" + daySelected + "');</script>");
}
// get cong viec public here
jobPublics = new Jobs();
jobPublicData = jobPublics.GetJobsPulic();
for (int i = 0; i < jobPublicData.Rows.Count; i++)
{
Jobs abc = new Jobs();
abc.job_id = (int)jobPublicData.Rows[i][0];
DataTable zzz = abc.GetAllContactsJobsPublic();
int run = 0;
for (int j = 0; j < zzz.Rows.Count; j++)
{
contactjobpublic[(int)jobPublicData.Rows[i][0], run++] = (string)zzz.Rows[j][1];
}
}
//
Account ac = new Account();
ac.id = Session["User_ID"].ToString();
dt = ac.GetJobByID(GetDayStartOfWeek(dbcon.Getcurrentday()));
if (dt.Rows.Count > 0)
{
day = (DateTime)dt.Rows[0][2];
// fill array contacts
DataTable cont = new DataTable();
Jobs job = new Jobs();
for (int i = 0; i < dt.Rows.Count; i++)
{
job.job_id = (int)dt.Rows[i][0];
cont = job.GetContact(Session["User_ID"].ToString());
int run = 0;
for (int j = 0; j < cont.Rows.Count; j++)
{
idcontacts[(int)dt.Rows[i][0], run] = (int)cont.Rows[j][0];
contacts[(int)dt.Rows[i][0], run] = cont.Rows[j][1].ToString();
run++;
}
//fill comment to arr
comment = job.Comments();
run = 0;
for (int j = 0; j < comment.Rows.Count; j++)
{
comments[(int)dt.Rows[i][0], run] = (string)comment.Rows[j][2];
idnvcomments[(int)dt.Rows[i][0], run] = comment.Rows[j][3].ToString();
namenvcomments[(int)dt.Rows[i][0], run] = (string)comment.Rows[j][4];
run++;
}
}
}
//GridView1.DataSource = dt;
//GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
title = " abc";
Jobs jobHandle = new Jobs();
if (Request.QueryString["daysearch"] != null)
{
title = Request.QueryString["daysearch"];
string daytam = Request.QueryString["daysearch"];
daySelected = daytam;
}
title = GetDayStartOfWeek(daySelected);
// dayshowonindex = DateTime.ParseExact(daySelected.ToString(), "dd-MM-yyyy", CultureInfo.InvariantCulture);
if (Request.QueryString["iddelete"] != null)
{
jobHandle.job_id = int.Parse(Request.QueryString["iddelete"]);
jobHandle.Delete();
ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "Thông báo: ", "<script>alert('Xóa công việc thành công');window.location='index.aspx';</script>");
}
if (Request.QueryString["idupdate"] != null)
{
jobHandle.job_id = int.Parse(Request.QueryString["idupdate"]);
jobHandle.job_title = Request.QueryString["textupdate"];
jobHandle.Update();
//title += Request.QueryString["idupdate"] + "-"+Request.QueryString["textupdate"].Trim()+";";
ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "Thông báo: ", "<script>alert('Cập nhật công việc thành công');window.location='index.aspx';</script>");
}
if (Request.QueryString["namecontact"] != null)
{
int idnv = int.Parse(Request.QueryString["namecontact"]);
jobHandle.job_id = int.Parse(Request.QueryString["namecontact_idjob"]);
jobHandle.DeleteOneContact(idnv);
//title += Request.QueryString["namecontact"].Trim() + "-"+Request.QueryString["namecontact_idjob"] +";";
ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "Thông báo: ", "<script>alert('Xóa cộng tác công việc thành công');window.location='index.aspx';</script>");
}
if (Request.QueryString["contact"] != null)
{
jobHandle.job_id = int.Parse(Request.QueryString["idjob"]);
jobHandle.AddContact(Request.QueryString["contact"].Trim());
//title += Request.QueryString["contact"].Trim() + "-"+Request.QueryString["idjob"] +";";
ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "Thông báo: ", "<script>alert('Thêm cộng tác công việc thành công');window.location='index.aspx';</script>");
}
if (Request.QueryString["job"] != null)
{
// title+= Request.QueryString["job"] +":"+ Request.QueryString["day"]+";";
string day = Request.QueryString["day"];
DateTime curday = new DateTime();
foreach (DateTime dayloop in EachDay(DateTime.Now, DateTime.Now.AddDays(5)))
{
curday = dayloop;
if (dayloop.DayOfWeek.ToString().Equals("Sunday"))
{
break;
}
if (dayloop.DayOfWeek.ToString().Equals(day))
{
break;
}
}
if (!curday.DayOfWeek.ToString().Equals(day))
{
ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "Cảnh báo: ", "<script>alert('Không thể thêm công việc cho quá khứ !!!');window.location='index.aspx';</script>");
}
else
{
jobHandle.job_id = jobHandle.CreateIdJobNext();
jobHandle.job_title = Request.QueryString["job"].Trim();
jobHandle.job_date = curday;
jobHandle.Insert((int)Session["User_ID"]);
ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "Thông báo: ", "<script>alert('Thêm công việc thành công.');window.location='index.aspx';</script>");
}
}
Account ac = new Account();
ac.id = Session["User_ID"].ToString();
dt = ac.GetJobByID(GetDayStartOfWeek(daySelected));
if (dt.Rows.Count > 0)
{
day = (DateTime)dt.Rows[0][2];
// fill array contacts
DataTable cont = new DataTable();
Jobs job = new Jobs();
for (int i = 0; i < dt.Rows.Count; i++)
{
job.job_id = (int)dt.Rows[i][0];
cont = job.GetContact(Session["User_ID"].ToString());
int run = 0;
for (int j = 0; j < cont.Rows.Count; j++)
{
idcontacts[(int)dt.Rows[i][0], run] = (int)cont.Rows[j][0];
contacts[(int)dt.Rows[i][0], run] = cont.Rows[j][1].ToString();
run++;
}
}
}
//GridView1.DataSource = dt;
//GridView1.DataBind();
}
