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; } }