protected void ddlProject_SelectedIndexChanged(object sender, EventArgs e)
{
objProjectCls = new ProjectClass();
DataTable dt = objProjectCls.GetProjectName(ddlProject.SelectedValue);
txtProjectName.Text = dt.Rows[0][0].ToString();
}
protected void GetProjectProgress(string username)
{
objProjectCls = new ProjectClass();
DataTable dt = objProjectCls.GetProjectProgressByID(username, Request.QueryString["cprj"], Request.QueryString["cact"]);
if (dt.Rows.Count > 0)
{
txtActivity.Text = dt.Rows[0]["t_cact"].ToString();
txtDescription.Text = dt.Rows[0]["t_dsca"].ToString();
txtScheduledStartDate.Text = Convert.ToDateTime(dt.Rows[0]["t_sdst"]).ToString("dd-MM-yyyy");
txtScheduledFinishDate.Text = Convert.ToDateTime(dt.Rows[0]["t_sdfn"]).ToString("dd-MM-yyyy");
txtRemarks.Text = dt.Rows[0]["t_remk"].ToString();
}
txtOutStartDate.Attributes.Add("type", "date");
if ((Convert.ToDateTime(dt.Rows[0]["t_otst"]).ToString("yyyy") == "1753" || Convert.ToDateTime(dt.Rows[0]["t_otst"]).ToString("yyyy") == "1900" || (dt.Rows[0]["t_otst"]).ToString() == string.Empty))
{
string sdate = "yyyy-MM-dd";
txtOutStartDate.Attributes.Add("value", sdate);
}
else
{
txtOutStartDate.Attributes.Add("value", Convert.ToDateTime(dt.Rows[0]["t_otst"]).ToString("yyyy-MM-dd"));
}
txtOutFinishDate.Attributes.Add("type", "date");
if ((Convert.ToDateTime(dt.Rows[0]["t_otfn"]).ToString("yyyy") == "1753" || Convert.ToDateTime(dt.Rows[0]["t_otfn"]).ToString("yyyy") == "1900" || (dt.Rows[0]["t_otfn"]).ToString() == string.Empty))
{
string fdate = "yyyy-MM-dd";
txtOutFinishDate.Attributes.Add("value", fdate);
}
else
{
txtOutFinishDate.Attributes.Add("value", Convert.ToDateTime(dt.Rows[0]["t_otfn"]).ToString("yyyy-MM-dd"));
}
txtActualStartDate.Attributes.Add("type", "date");
if ((Convert.ToDateTime(dt.Rows[0]["t_acsd"]).ToString("yyyy") == "1753" || Convert.ToDateTime(dt.Rows[0]["t_acsd"]).ToString("yyyy") == "1900" || (dt.Rows[0]["t_acsd"]).ToString() == string.Empty))
{
string sdate = "yyyy-MM-dd";
txtActualStartDate.Attributes.Add("value", sdate);
}
else
{
txtActualStartDate.Attributes.Add("value", Convert.ToDateTime(dt.Rows[0]["t_acsd"]).ToString("yyyy-MM-dd"));
}
txtActualFinishDate.Attributes.Add("type", "date");
if ((Convert.ToDateTime(dt.Rows[0]["t_acfn"]).ToString("yyyy") == "1753" || Convert.ToDateTime(dt.Rows[0]["t_acfn"]).ToString("yyyy") == "1900" || (dt.Rows[0]["t_acfn"]).ToString() == string.Empty))
{
string fdate = "yyyy-MM-dd";
txtActualFinishDate.Attributes.Add("value", fdate);
}
else
{
txtActualFinishDate.Attributes.Add("value", Convert.ToDateTime(dt.Rows[0]["t_acfn"]).ToString("yyyy-MM-dd"));
//btnUpdate.Enabled = false;
}
}
private void BindProjectId()
{
objProjectCls = new ProjectClass();
DataTable dt = objProjectCls.GetProjectId();
ddlProject.DataSource = dt;
ddlProject.DataTextField = "t_cprj";
ddlProject.DataValueField = "t_cprj";
ddlProject.DataBind();
ddlProject.Items.Insert(0, "Select");
}
private void GetProjectProgress()
{
objProjectCls = new ProjectClass();
DataTable dt = objProjectCls.GetProjectProgressByID(Request.QueryString["cprj"], Request.QueryString["cact"]);
if (dt.Rows.Count > 0)
{
txtActivity.Text = dt.Rows[0]["t_cact"].ToString();
txtDescription.Text = dt.Rows[0]["t_dsca"].ToString();
txtScheduledStartDate.Text = Convert.ToDateTime(dt.Rows[0]["t_sdst"]).ToString("dd-MM-yyyy");
txtScheduledFinishDate.Text = Convert.ToDateTime(dt.Rows[0]["t_sdfn"]).ToString("dd-MM-yyyy");
txtActualStartDate.Text = Convert.ToDateTime(dt.Rows[0]["t_acsd"]).ToString("dd-MM-yyyy");
txtActualFinishDate.Text = Convert.ToDateTime(dt.Rows[0]["t_acfn"]).ToString("dd-MM-yyyy");
}
}
private void GetProject()
{
DataTable dt = new DataTable();
if (HttpContext.Current.Cache["ProjectData"] == null)
{
objProjectCls = new ProjectClass();
string ProjectId = ddlProject.SelectedValue;
dt = objProjectCls.GetProject(ProjectId);
gvData.DataSource = dt;
gvData.DataBind();
HttpContext.Current.Cache.Insert("ProjectData", dt, null, DateTime.Now.AddMinutes(20), TimeSpan.Zero);
}
else
{
dt = (DataTable)HttpContext.Current.Cache["ProjectData"];
}
}
protected void ValidateUser(string Id, string password)
{
objProjectCls = new ProjectClass();
DataTable dt = new DataTable();
dt = objProjectCls.GetUserRecord(Id, password);
Session["Username"] = Id;
if (dt.Rows.Count > 0)
{
Session["projId"] = dt.Rows[0]["t_cprj"];
Session["day"] = dt.Rows[0]["t_day"];
Session["projName"] = dt.Rows[0]["t_dsca"];
Response.Redirect("ProjectProgressReport.aspx");
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page),
"alert", "alert('The Login Id and/or password you have entered is invalid');", true);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
objProjectCls = new ProjectClass();
string Actual_SDate = Convert.ToDateTime(txtActualStartDate.Text).ToString("yyyy-MM-dd");
string Actual_FDate = Convert.ToDateTime(txtActualFinishDate.Text).ToString("yyyy-MM-dd");
int res = objProjectCls.UpdateActualDates(Request.QueryString["cprj"], Request.QueryString["cact"], Actual_SDate, Actual_FDate);
if (res > 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Successfully Updated');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Updated');", true);
}
}
catch (Exception ex)
{
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string sUsername = (string)(Session["Username"]);
string Actual_SDate;
string Actual_FDate;
string Outlook_SDate;
string Outlook_FDate;
string Remarks;
try
{
objProjectCls = new ProjectClass();
if (txtOutStartDate.Text == "")
{
Outlook_SDate = "";
}
else
{
Outlook_SDate = Convert.ToDateTime(txtOutStartDate.Text).ToString("yyyy-MM-dd");
}
if (txtOutFinishDate.Text == "")
{
Outlook_FDate = "";
}
else
{
Outlook_FDate = Convert.ToDateTime(txtOutFinishDate.Text).ToString("yyyy-MM-dd");
}
if (txtActualStartDate.Text == "")
{
Actual_SDate = "";
}
else
{
Actual_SDate = Convert.ToDateTime(txtActualStartDate.Text).ToString("yyyy-MM-dd");
}
if (txtActualFinishDate.Text == "")
{
Actual_FDate = "";
}
else
{
Actual_FDate = Convert.ToDateTime(txtActualFinishDate.Text).ToString("yyyy-MM-dd");
}
if (txtRemarks.Text == "")
{
Remarks = "";
}
else
{
Remarks = txtRemarks.Text.ToString();
}
int res = objProjectCls.UpdatRecords(sUsername, Request.QueryString["cprj"], Request.QueryString["cact"], Actual_SDate, Actual_FDate, Remarks, Outlook_SDate, Outlook_FDate);
if (res > 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Successfully Updated');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Updated');", true);
}
}
catch (Exception ex)
{
string tt = ex.Message;
}
}
