protected void btnCompleted_Command(object sender, CommandEventArgs e)
{
if (Request.QueryString["TID"] != null)
{
long timestamp = Convert.ToInt64(Request.QueryString["TID"]);
DataSet theDataSet = new DataSet();
theDataSet.ReadXml(Server.MapPath("AllTeams/" + SessionManager.LoggedInUTCode + "/TaskOngoing.cs"));
DataTable dtTask = theDataSet.Tables[0];
DataRow[] drow = dtTask.Select("Timestamp = " + timestamp);
drow[0]["Status"] = "Completed";
drow[0]["RemarksDate"] = DateTime.Now.Date.ToString();
dtTask.AcceptChanges();
theDataSet.AcceptChanges();
String xmldata = CommonUtility.DSToXml(theDataSet);
String folderFiles = Server.MapPath("AllTeams/" + SessionManager.LoggedInUTCode + "/TaskOngoing.cs");
File.WriteAllText(folderFiles, xmldata);
Response.Redirect("UserTaskDetail.aspx?TID=" + timestamp.ToString());
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataSet theDataSet = new DataSet();
string path = Server.MapPath("AllTeams/" + SessionManager.LoggedInTCode + "/TaskOngoing.cs");
theDataSet.ReadXml(Server.MapPath("AllTeams/" + SessionManager.LoggedInTCode + "/TaskOngoing.cs"));
DataTable dt = theDataSet.Tables[0];
//DataRow[] drow = dt.Select("TCode = '" + txtTeamCode.Text + "'");
//if (drow.Length > 0)
//{
// ScriptManager.RegisterClientScriptBlock(btnSave, btnSave.GetType(), "btnSave", "alert('TCode already used.')", true);
// return;
//}
DataRow row;
row = dt.NewRow();
row["Timestamp"] = DateTime.Now.Ticks.ToString();
row["Task"] = txtTask.Text;
if (ddlUser.SelectedValue != "")
{
row["UCode"] = ddlUser.SelectedValue;
row["Name"] = ddlUser.SelectedItem.Text;
row["Status"] = "Pending";
}
else
{
row["UCode"] = "";
row["Name"] = "";
row["Status"] = "Unallocated";
}
string dateC = DateTime.Now.Date.ToString();
row["CreateDate"] = DateTime.Now.Date.ToString();
var TargetDate = CommonUtility.StringToDateTime(txtTargetDate.Text, "dd-MM-yyyy");
if (TargetDate.HasValue)
{
row["TargetDate"] = TargetDate;
}
else
{
row["TargetDate"] = DateTime.Today;
}
dt.Rows.Add(row);
dt.AcceptChanges();
theDataSet.AcceptChanges();
String xmldata = CommonUtility.DSToXml(theDataSet);
String folderFiles = Server.MapPath("AllTeams/" + SessionManager.LoggedInTCode + "/TaskOngoing.cs");
File.WriteAllText(folderFiles, xmldata);
Response.Redirect("TaskNew.aspx?msg=success");
}
protected void btnClosed_Command(object sender, CommandEventArgs e)
{
if (e.CommandArgument != null)
{
long timestamp = Convert.ToInt64(e.CommandArgument.ToString());
DataSet theDataSet = new DataSet();
theDataSet.ReadXml(Server.MapPath("AllTeams/" + SessionManager.LoggedInTCode + "/TaskOngoing.cs"));
DataTable dtTask = theDataSet.Tables[0];
DataRow[] drow = dtTask.Select("Timestamp = " + timestamp);
//drow[0]["Status"] = "Closed";
DataSet theDataSet2 = new DataSet();
theDataSet2.ReadXml(Server.MapPath("AllTeams/" + SessionManager.LoggedInTCode + "/TaskClosed.cs"));
DataTable dtTask2 = theDataSet2.Tables[0];
DataRow row = dtTask2.NewRow();
row["Timestamp"] = drow[0]["Timestamp"];
row["Task"] = drow[0]["Task"];
row["Status"] = drow[0]["Status"];
row["UCode"] = drow[0]["UCode"];
row["Name"] = drow[0]["Name"];
row["CreateDate"] = drow[0]["CreateDate"];
row["TargetDate"] = drow[0]["TargetDate"];
row["Remarks"] = drow[0]["Remarks"];
row["RemarksDate"] = drow[0]["RemarksDate"];
dtTask2.Rows.Add(row);
dtTask2.AcceptChanges();
theDataSet2.AcceptChanges();
drow[0].Delete();
dtTask.AcceptChanges();
theDataSet.AcceptChanges();
String xmldata = CommonUtility.DSToXml(theDataSet);
String folderFiles = Server.MapPath("AllTeams/" + SessionManager.LoggedInTCode + "/TaskOngoing.cs");
File.WriteAllText(folderFiles, xmldata);
//Response.Redirect("TaskListOnGoing.aspx");
String xmldata2 = CommonUtility.DSToXml(theDataSet2);
String folderFiles2 = Server.MapPath("AllTeams/" + SessionManager.LoggedInTCode + "/TaskClosed.cs");
File.WriteAllText(folderFiles2, xmldata2);
Response.Redirect("TaskListOnGoing.aspx");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataSet theDataSet = new DataSet();
string path = Server.MapPath("AllTeams/" + SessionManager.LoggedInTCode + "/TaskOngoing.cs");
theDataSet.ReadXml(Server.MapPath("AllTeams/" + SessionManager.LoggedInTCode + "/TaskOngoing.cs"));
DataTable dt = theDataSet.Tables[0];
long timestamp = Convert.ToInt64(Request.QueryString["TID"]);
DataRow[] row = dt.Select("Timestamp = " + timestamp);
row[0]["Status"] = ddlUser.SelectedValue == "" ? "Unallocated" : ddlStatus.SelectedValue;
//row[0]["Timestamp"] = Convert.ToInt64(row[0]["Timestamp"]);
row[0]["Task"] = txtTask.Text;
if (ddlUser.SelectedValue != "")
{
row[0]["UCode"] = ddlUser.SelectedValue;
row[0]["Name"] = ddlUser.SelectedItem.Text;
if (row[0]["Status"].ToString() == "Unallocated")
{
row[0]["Status"] = "Pending";
}
}
else
{
row[0]["UCode"] = "";
row[0]["Name"] = "";
}
var TargetDate = CommonUtility.StringToDateTime(txtTargetDate.Text, "dd-MM-yyyy");
if (TargetDate.HasValue)
{
row[0]["TargetDate"] = TargetDate;
}
row[0]["Remarks"] = txtRemarks.Text;
//dt.Rows.Add(row);
dt.AcceptChanges();
theDataSet.AcceptChanges();
String xmldata = CommonUtility.DSToXml(theDataSet);
String folderFiles = Server.MapPath("AllTeams/" + SessionManager.LoggedInTCode + "/TaskOngoing.cs");
File.WriteAllText(folderFiles, xmldata);
Response.Redirect("TaskEdit.aspx?TID=" + Request.QueryString["TID"] + "&msg=success");
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataSet theDataSet = new DataSet();
theDataSet.ReadXml(Server.MapPath("AllTeams/dbteams.cs"));
DataTable dt = theDataSet.Tables[0];
DataRow[] drow = dt.Select("TCode = '" + txtTeamCode.Text + "'");
if (drow.Length > 0)
{
ScriptManager.RegisterClientScriptBlock(btnSave, btnSave.GetType(), "btnSave", "alert('TCode already used.')", true);
return;
}
DataRow row;
row = dt.NewRow();
row["TCode"] = txtTeamCode.Text;
row["Password"] = txtPassword.Text;
row["TeamName"] = txtTeamName.Text;
row["IsActive"] = chkActive.Checked;
row["StartDate"] = CommonUtility.StringToDateTime(txtStartDate.Text, "dd-MM-yyyy").Value.ToString("yyyy-MM-dd HH:mm:ss");
row["EndDate"] = CommonUtility.StringToDateTime(txtEndDate.Text, "dd-MM-yyyy").Value.ToString("yyyy-MM-dd HH:mm:ss");
row["Remarks"] = txtRemarks.Text;
row["MaxUsers"] = txtMaxUsers.Text;
dt.Rows.Add(row);
dt.AcceptChanges();
theDataSet.AcceptChanges();
String xmldata = CommonUtility.DSToXml(theDataSet);
File.WriteAllText(Server.MapPath("AllTeams/dbteams.cs"), xmldata);
String folderFiles = Server.MapPath("AllTeams/" + txtTeamCode.Text);
System.IO.Directory.CreateDirectory(folderFiles);
CreateTaskFiles(txtTeamCode.Text);
Response.Redirect("TeamNew.aspx?msg=success");
}
protected void CreateTaskFiles(string TeamCode)
{
DataTable dt = new DataTable("Ongoing");
dt.Columns.Add("Timestamp", typeof(long));
dt.Columns.Add("Task", typeof(string));
dt.Columns.Add("Status", typeof(string));
dt.Columns.Add("UCode", typeof(string));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("CreateDate", typeof(DateTime));
dt.Columns.Add("TargetDate", typeof(DateTime));
dt.Columns.Add("Remarks", typeof(string));
dt.Columns.Add("RemarksDate", typeof(DateTime));
DataRow row;
row = dt.NewRow();
row["Timestamp"] = DateTime.Now.Ticks.ToString();
row["Task"] = "Task1";
row["Status"] = "Status1";
row["UCode"] = "usercode1";
row["Name"] = "Name1";
row["CreateDate"] = DateTime.Now;
row["TargetDate"] = DateTime.Today;
dt.Rows.Add(row);
dt.AcceptChanges();
DataSet theDataSet = new DataSet();
theDataSet.Tables.Add(dt);
theDataSet.AcceptChanges();
string xmldata = CommonUtility.DSToXml(theDataSet);
string OngoingTaskFile = Server.MapPath("AllTeams/" + TeamCode + "/TaskOngoing.cs");
File.WriteAllText(OngoingTaskFile, xmldata);
string CompletedTaskFile = Server.MapPath("AllTeams/" + TeamCode + "/TaskClosed.cs");
File.WriteAllText(CompletedTaskFile, xmldata);
}
protected void btnCompleted_Command(object sender, CommandEventArgs e)
{
if (e.CommandArgument != null)
{
long timestamp = Convert.ToInt64(e.CommandArgument.ToString());
DataSet theDataSet = new DataSet();
theDataSet.ReadXml(Server.MapPath("AllTeams/" + SessionManager.LoggedInTCode + "/TaskOngoing.cs"));
DataTable dtTask = theDataSet.Tables[0];
DataRow[] drow = dtTask.Select("Timestamp = " + timestamp);
drow[0]["Status"] = "Completed";
dtTask.AcceptChanges();
theDataSet.AcceptChanges();
String xmldata = CommonUtility.DSToXml(theDataSet);
String folderFiles = Server.MapPath("AllTeams/" + SessionManager.LoggedInTCode + "/TaskOngoing.cs");
File.WriteAllText(folderFiles, xmldata);
Response.Redirect("TaskListOnGoing.aspx");
}
}
private void mtaskupdate() // ucode, password, status, remarks, timestamp
{
string usercode = Request.Params["ucode"];
string password = Request.Params["password"];
DataSet dsUsers = new DataSet();
dsUsers.ReadXml(Server.MapPath("AllTeams/dbusers.cs"));
DataTable dtUser = dsUsers.Tables[0];
DataRow[] drow = dtUser.Select("UCode = '" + usercode + "' AND Password = '******'");
DataSet dsTasks = new DataSet();
string path = Server.MapPath("/AllTeams/" + drow[0]["TCode"].ToString() + "/TaskOngoing.cs");
dsTasks.ReadXml(path);
DataTable dtTask = dsTasks.Tables[0];
string filter = "UCode = '" + Request.Params["ucode"] + "' AND timestamp = '" + Request.Params["timestamp"] + "'";
var arr = dtTask.Select(filter);
arr[0]["Status"] = Request.Params["status"];
arr[0]["Remarks"] = Request.Params["remarks"];
arr[0]["RemarksDate"] = DateTime.Now;
dtTask.AcceptChanges();
dsTasks.AcceptChanges();
String xmldata = CommonUtility.DSToXml(dsTasks);
String folderFiles = Server.MapPath("AllTeams/" + drow[0]["TCode"].ToString() + "/TaskOngoing.cs");
File.WriteAllText(folderFiles, xmldata);
Response.Write(@"{""responsecode"":""1""}");
return;
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataSet theDataSet = new DataSet();
theDataSet.ReadXml(Server.MapPath("AllTeams/dbusers.cs"));
DataTable dt = theDataSet.Tables[0];
if (Request.QueryString["ucode"] != null)
{
DataRow[] drow = dt.Select("UCode = '" + txtUserCode.Text + "'");
if (txtPassword.Text != null && txtPassword.Text != "")
{
drow[0]["Password"] = txtPassword.Text;
}
drow[0]["Name"] = txtName.Text;
drow[0]["Email"] = txtEmail.Text;
//drow[0]["TCode"] = SessionManager.LoggedInTCode;
drow[0]["IsActive"] = chkActive.Checked;
drow[0]["Remarks"] = txtRemarks.Text;
//dt.Rows.Add(drow);
dt.AcceptChanges();
theDataSet.AcceptChanges();
String xmldata = CommonUtility.DSToXml(theDataSet);
File.WriteAllText(Server.MapPath("AllTeams/dbusers.cs"), xmldata);
Response.Redirect("UserDetails.aspx?ucode=" + txtUserCode.Text);
}
else
{
DataRow[] drow = dt.Select("UCode = '" + txtUserCode.Text + "'");
if (drow.Length > 0)
{
ScriptManager.RegisterClientScriptBlock(btnSave, btnSave.GetType(), "btnSave", "alert('User Code not available. Please use another user code.')", true);
return;
}
DataRow row;
row = dt.NewRow();
row["UCode"] = txtUserCode.Text;
row["Password"] = txtPassword.Text;
row["Name"] = txtName.Text;
row["Email"] = txtEmail.Text;
row["TCode"] = SessionManager.LoggedInTCode;
row["IsActive"] = chkActive.Checked;
row["Remarks"] = txtRemarks.Text;
dt.Rows.Add(row);
dt.AcceptChanges();
theDataSet.AcceptChanges();
String xmldata = CommonUtility.DSToXml(theDataSet);
File.WriteAllText(Server.MapPath("AllTeams/dbusers.cs"), xmldata);
String userFile = Server.MapPath("AllTeams/" + SessionManager.LoggedInTCode + "/" + txtUserCode.Text);
System.IO.Directory.CreateDirectory(userFile);
Response.Redirect("UserDetails.aspx?ucode=" + txtUserCode.Text);
}
}