protected void Page_Load(object sender, EventArgs e) { whitfielduser wUser = new whitfielduser(); DataSet dsUser = wUser.GetUserRecord("admin"); DataTable myControls; myControls = dsUser.Tables[0]; if (myControls.Rows.Count > 0) { try { foreach (DataRow dRow in myControls.Rows) { Response.Write(dRow["FirstName"].ToString() + " " + dRow["LastName"].ToString()); Response.Write(dRow["LoginId"].ToString().Trim()); Response.Write(dRow["EmployeeNo"].ToString().Trim()); Response.Write( dRow["RoleId"].ToString().Trim()); } } catch (Exception ex) { HttpResponse objResponse = HttpContext.Current.Response; objResponse.Write(ex.Message); } } }
public void grdManPower_DeleteCommand(object sender, DataGridCommandEventArgs e) { whitfielduser _wRep = new whitfielduser(); String worker_id = ""; worker_id = grdManPower.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString(); _wRep.DeleteWorkerRecord(worker_id); this.DisplayManPowerGrid(); }
public void grdManPower_UpdateCommand(object sender, DataGridCommandEventArgs e) { String ManPower_id = ""; ManPower_id = grdManPower.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString(); whitfielduser _wRep = new whitfielduser(); _wRep.UpdateWorkers(Convert.ToInt32(ManPower_id), ((TextBox)(e.Item.FindControl("txtfirstname"))).Text, ((TextBox)(e.Item.FindControl("txtlastname"))).Text, ((TextBox)(e.Item.FindControl("txtStreet"))).Text, ((TextBox)(e.Item.FindControl("txtCity"))).Text, ((DropDownList)(e.Item.FindControl("ddlstate"))).SelectedItem.Value, ((TextBox)(e.Item.FindControl("txtRate"))).Text, Convert.ToInt32(((DropDownList)(e.Item.FindControl("ddlworker_type"))).SelectedItem.Value), ((TextBox)(e.Item.FindControl("txtssn"))).Text, Request.Cookies["UserId"].Value.Trim()); grdManPower.EditItemIndex = -1; grdManPower.ShowFooter = true; this.DisplayManPowerGrid(); }
public void LoginUser() { //[FirstName] [varchar](50) NOT NULL, //[LastName] [varchar](50) NOT NULL, //[Address] [varchar](250) NOT NULL, //[City] [varchar](50) NOT NULL, //[State] [varchar](50) NOT NULL, //[Zip] [varchar](50) NOT NULL, //[ContactNo1] [varchar](50) NOT NULL, //[ContactNo2] [varchar](50) NOT NULL, //[LoginId] [varchar](50) NOT NULL, //[Password] [varchar](50) NOT NULL, //[CreatedBy] [int] NULL, //[CreatedOn] [datetime] NULL, //[ModifiedBy] [int] NULL, //[ModifiedOn] [timestamp] NULL, //[EmployeeNo] [varchar](50) NOT NULL, //[IsActive] [bit] NOT NULL whitfielduser wUser = new whitfielduser(); if (wUser.IsUserExists(tbUserID.Text.Trim(),tbpassword.Text.Trim())) { DataSet dsUser = wUser.GetUserRecord(tbUserID.Text.Trim()); DataTable myControls; myControls = dsUser.Tables[0]; if (myControls.Rows.Count > 0) { try { foreach (DataRow dRow in myControls.Rows) { Response.Cookies["useridentifier"].Value = dRow["Userid"].ToString().Trim(); Response.Cookies["Name"].Value = dRow["FirstName"].ToString() +" " + dRow["LastName"].ToString(); Response.Cookies["UserId"].Value = dRow["LoginId"].ToString().Trim(); Response.Cookies["EmployeeNo"].Value = dRow["EmployeeNo"].ToString().Trim(); Response.Cookies["RoleId"].Value = dRow["RoleId"].ToString().Trim(); if (dRow["RoleId"].ToString().Trim() == "5") Response.Redirect("installer_projects.aspx"); else Response.Redirect("whitfieldmain.aspx"); } } catch (Exception ex) { HttpResponse objResponse = HttpContext.Current.Response; objResponse.Write(ex.Message); } } } else{ lblMsg.Text = "Check your Userid and password"; } }
public void BindEmployees() { DataSet dsGrp = new DataSet(); whitfielduser wUser = new whitfielduser(); dsGrp = wUser.GetProjectUsersNoInstallers(); if (dsGrp.Tables[0].Rows.Count > 0) { ddlEmpl.DataSource = dsGrp; ddlEmpl.DataTextField = "uName"; ddlEmpl.DataValueField = "loginId"; ddlEmpl.DataBind(); ddlEmpl.Items.Insert(0, common.AddItemToList("Select Worker", "0")); } }
private void BindCitiesforState() { DataSet dsGrp = new DataSet(); whitfielduser wUser = new whitfielduser(); dsGrp = wUser.GetCitiesForStates(ddlstate.SelectedItem.Value.Trim()); if (dsGrp.Tables[0].Rows.Count > 0) { ddlcity.DataSource = dsGrp; ddlcity.DataTextField = "city"; ddlcity.DataValueField = "Cityid"; ddlcity.DataBind(); ddlcity.Items.Insert(0, common.AddItemToList("All", "")); } }
protected void btnupdate_Click(object sender, EventArgs e) { whitfielduser wUser = new whitfielduser(); if (wUser.IsUserExists(txtloginid.Text.Trim(),txtoldpasswd.Text.Trim())) { if (wUser.ChangePass(txtloginid.Text.Trim(), txtnewpasswd.Text.Trim())) { lblErrMsg.Text = "Your Password is successfully changed, please close the window and login"; } else { lblErrMsg.Text = "Please check your userid and password."; } } else { lblErrMsg.Text = "Please check your Userid and Password and try again."; } }
protected void btnnew_Click(object sender, EventArgs e) { whitfielduser wUser = new whitfielduser(); Boolean isInsert = wUser.ManageUsers(txtfn.Text.Trim(), txtln.Text.Trim(), txtaddress.Text.Trim(), ddlcity.SelectedItem.Value, ddlstate.SelectedItem.Value, txtzip.Text.Trim(), txtphno.Text.Trim(), txtuserid.Text.Trim(), txtpasswd.Text.Trim(), txtEmpNo.Text.Trim(), "1", txtem.Text.Trim(), txtrate.Text.Trim(), ddlrole.SelectedItem.Value, Convert.ToInt32(ddlEmplyType.SelectedItem.Value) ); Response.Redirect("whitfield_users.aspx"); }
protected void Page_Load(object sender, EventArgs e) { whitfielduser _wuser = new whitfielduser(); if (!Page.IsPostBack) { Bindroles(); Bindstates(); BindEmplyeeType(); if (Request.QueryString["hFlag"] == "E") { DataSet dsUser = _wuser.GetUserRecord(Request.QueryString["hUserid"]); DataTable dtUsr = dsUser.Tables[0]; foreach (DataRow dRow in dtUsr.Rows) { txtfn.Text = dRow["FirstName"].ToString(); txtln.Text = dRow["LastName"].ToString(); txtem.Text = dRow["email_address"].ToString(); txtEmpNo.Text = dRow["EmployeeNo"].ToString(); txtaddress.Text = dRow["Address"].ToString(); txtphno.Text = dRow["ContactNo1"].ToString(); BindCitiesforState(dRow["state"].ToString()); ddlstate.SelectedIndex = ddlstate.Items.IndexOf(ddlstate.Items.FindByValue(dRow["state"].ToString())); ddlcity.SelectedIndex = ddlcity.Items.IndexOf(ddlcity.Items.FindByValue(dRow["city"].ToString())); txtzip.Text = dRow["zip"].ToString(); txtuserid.Text = dRow["Loginid"].ToString(); txtpasswd.Text = dRow["password"].ToString(); ddlrole.SelectedIndex = ddlrole.Items.IndexOf(ddlrole.Items.FindByValue(dRow["roleid"].ToString())); ddlEmplyType.SelectedIndex = ddlEmplyType.Items.IndexOf(ddlEmplyType.Items.FindByValue(dRow["empl_type_id"].ToString())); txtrate.Text = dRow["hourly_rate"].ToString(); } } else { txtuserid.ReadOnly = false; } } }
private void Bindstates() { DataSet dsGrp = new DataSet(); whitfielduser wUser = new whitfielduser(); dsGrp = wUser.GetStates(); if (dsGrp.Tables[0].Rows.Count > 0) { ddlstate.DataSource = dsGrp; ddlstate.DataTextField = "State"; ddlstate.DataValueField = "statecd"; ddlstate.DataBind(); ddlstate.Items.Insert(0, common.AddItemToList("All", "")); } }
private void BindEmplyeeType() { DataSet dsGrp = new DataSet(); whitfielduser wUser = new whitfielduser(); dsGrp = wUser.GetEmplyeeTypes(); if (dsGrp.Tables[0].Rows.Count > 0) { ddlEmplyType.DataSource = dsGrp; ddlEmplyType.DataTextField = "empl_type_name"; ddlEmplyType.DataValueField = "empl_type_id"; ddlEmplyType.DataBind(); ddlEmplyType.Items.Insert(0, common.AddItemToList("Select Emplyee Type", "")); } }
public DataSet FetchProjectUsers() { DataSet dsGrp = new DataSet(); whitfielduser wUser = new whitfielduser(); dsGrp = wUser.GetProjectUsers(); return dsGrp; }
private void BindEmplyeeTypes() { DataSet dsGrp = new DataSet(); whitfielduser wUser = new whitfielduser(); if (Request.Cookies["RoleId"].Value == "5") dsGrp = wUser.FetchWorkersForInstaller(Request.Cookies["UserId"].Value); else dsGrp = wUser.FetchAllWorkers(); if (dsGrp.Tables[0].Rows.Count > 0) { ddlEmplType.DataSource = dsGrp; ddlEmplType.DataTextField = "worker_name"; ddlEmplType.DataValueField = "worker_id"; ddlEmplType.DataBind(); ddlEmplType.Items.Insert(0, common.AddItemToList("Select Manpower", "0")); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { try { grdRpResults.PageSize = _DEFAULTPAGESIZE; BindControls(); DataSet dsGridResults; dsGridResults = this.Summary_Queue(); this.PopulateDataGrid(dsGridResults); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } if (Request.QueryString["hFlag"] == "D") { whitfielduser wUser = new whitfielduser(); bool flg = wUser.DeleteRecord(Request.QueryString["hUserid"].Trim()); if (flg == true) { string url = "whitfield_users.aspx"; Response.Redirect(url); } } } else { grdRpResults.PageSize = 10; } }
protected void btnnew_Click(object sender, EventArgs e) { whitfielduser wUser = new whitfielduser(); Boolean isInsert = wUser.ManageWorkers(txtfn.Text.Trim(), txtln.Text.Trim(), txtaddress.Text.Trim(), txtCity.Text.Trim(), ddlstate.SelectedItem.Value, txtrate.Text.Trim(), Convert.ToInt32(ddlEmplyType.SelectedItem.Value), txtSSN.Text.Trim(), Request.Cookies["UserId"].Value ); if (Request.Cookies["RoleId"].Value == "5") Response.Write("<script language='javascript'>parent.location.replace('InstallerReports.aspx?EstNum=" + ViewState["EstNum"].ToString() + "&twc_project_number=" + ViewState["twcProjectNumber"].ToString() + "');</script>"); else Response.Write("<script language='javascript'>parent.location.replace('Whitfield_projectInfo.aspx?EstNum=" + ViewState["EstNum"].ToString() + "&twc_project_number=" + ViewState["twcProjectNumber"].ToString() + "');</script>"); }
protected DataSet FetchEmplyeeTypes() { DataSet dsGrp = new DataSet(); whitfielduser wUser = new whitfielduser(); dsGrp = wUser.GetEmplyeeTypesNOPM(); return dsGrp; }
protected DataSet FetchStates() { DataSet dsStates = new DataSet(); whitfielduser wUser = new whitfielduser(); dsStates = wUser.GetStates(); return dsStates; }
protected void Page_Load(object sender, EventArgs e) { whitfielduser _wuser = new whitfielduser(); if (!Page.IsPostBack) { Bindstates(); BindEmplyeeType(); // 1 Get collection NameValueCollection n = Request.QueryString; // 2 See if any query string exists if (n.HasKeys()) { // 3 Get first key and value string k = n.GetKey(0); string v = n.Get(0); string v1 = n.Get(1); // 4 // Test different keys EstNum = Convert.ToInt32(v); twcProjectNumber = Convert.ToInt32(v1); hidEstNum.Value = EstNum.ToString(); hidtwcProjNumber.Value = twcProjectNumber.ToString(); } ViewState["EstNum"] = EstNum; ViewState["twcProjectNumber"] = twcProjectNumber; this.DisplayManPowerGrid(); } }
private void DisplayManPowerGrid() { whitfielduser _wUser = new whitfielduser(); DataSet _dsRep = new DataSet(); if (Request.Cookies["RoleId"].Value == "5") _dsRep = _wUser.FetchWorkersForInstaller(Request.Cookies["UserId"].Value); else _dsRep = _wUser.FetchAllWorkers(); this.PopulateManPowerDataGrid(_dsRep); }
private void sendEmail(String _estNum, String filenm, String IsFinancial) { Whitfieldcore _wcore = new Whitfieldcore(); whitfielduser _wuser = new whitfielduser(); using (DataSet dsContacts = _wcore.GetContactsForProject(Convert.ToInt32(_estNum))) { DataTable dtContacts = dsContacts.Tables[0]; if (dtContacts.Rows.Count > 0) { foreach (DataRow dRow in dtContacts.Rows) { String _contactNm = dRow["contactName"] == DBNull.Value ? " " : dRow["contactName"].ToString(); String _contactEmail = dRow["email"] == DBNull.Value ? " " : dRow["email"].ToString(); String _clientnm = dRow["Name"] == DBNull.Value ? " " : dRow["Name"].ToString(); String _contactNumber = _wuser.GetContactNo(prjEsti); String mode = ""; if (IsFinancial == "Y") { mode = "Proposal"; } else { mode = "Scope"; } //HHS Uncomment this portion when there is an email list. MailMessage message = new MailMessage(); //message.To.Add(System.Configuration.ConfigurationManager.AppSettings["devEmail"]); //message.To.Add(System.Configuration.ConfigurationManager.AppSettings["AdminEmail"].ToString()); message.To.Add(_contactEmail); //This will be added once JW oks the function message.To.Add(System.Configuration.ConfigurationManager.AppSettings["EstimatingEmail"].ToString()); //This is tested for contact Email, remove once JW oks the function. message.From = new MailAddress(System.Configuration.ConfigurationManager.AppSettings["EstimatingEmail"]); message.Subject = txtprjname + " Architectural Millwork - WhitfieldCo - " + mode; message.IsBodyHtml = true; StringBuilder sb = new StringBuilder(); sb.Append("<html><head></head>"); sb.Append("<body>"); sb.Append("<TABLE cellSpacing='0' cellPadding='0' width='100%' border='0'><TR>"); sb.Append("<TD>"); sb.Append(_contactNm.Replace(",", " ") + ",<br>"); sb.Append("<br>Thank you for the opportunity to provide pricing on the " + txtprjname + " project for " + _clientnm + ". <br>"); sb.Append("<br>Please find attached our " + mode + " for the Custom Architectural Millwork which includes a complete and comprehensive scope for this work.<br>"); sb.Append("<br>You may contact me at " + _contactNumber + " with any questions regarding this estimate.<br>"); //sb.Append(<br>"_wuser.GetEstimatorName(prjEsti)); sb.Append("<br>" + txtNotes); sb.Append("<br><br>" + _wuser.GetEstimatorName(prjEsti)+ ",<br>"); sb.Append("Estimator"); sb.Append("<br><br>"); sb.Append("</TD>"); sb.Append("</TR></TABLE>"); //Footer sb.Append("<TABLE cellSpacing='0' cellPadding='0' width='100%' border='0'><TR>"); sb.Append("<TD><IMG height='80' alt='' src='http://www.whitfield-co.com/whitfield-co/assets/img/TWC%20Primary%20Logo1.JPG' border='0'></TD></TR>"); sb.Append("<TR><TD class='form1' vAlign='bottom' align='left' width='100%'><b>The Whitfield Co., Inc.<br>"); sb.Append("8836 Washington Blvd., Ste 101<br>"); sb.Append("Jessup, MD 20794<br>"); sb.Append("(301)-483-0791<br>"); sb.Append("(301)-483-0792<br>"); sb.Append("http://www.whitfield-co.com<br>"); sb.Append("<IMG height='9' alt='' src='http://www.whitfield-co.com/whitfield-co/assets/img/images.gif' width='1'>"); sb.Append("</TD>"); sb.Append("</TR></TABLE>"); sb.Append("</body></html>"); message.Body = sb.ToString(); message.Attachments.Add(new System.Net.Mail.Attachment(HttpContext.Current.Server.MapPath("~/attachments/") + filenm)); SmtpClient smtp = new SmtpClient(System.Configuration.ConfigurationManager.AppSettings["smtp"]); smtp.Send(message); if (!_contactEmail.Equals("")) { _wcore.InsertEmailConversation(Convert.ToInt32(_estNum), _contactEmail, _contactNm, DateTime.Now.ToString("MM-dd-yyyy"), DateTime.Now.ToString("T"), mode); } } } } }
private void BindControls() { DataSet dsGrp = new DataSet(); whitfielduser wUser = new whitfielduser(); dsGrp = wUser.GetAllRoles(); if (dsGrp.Tables[0].Rows.Count > 0) { ddlrole.DataSource = dsGrp; ddlrole.DataTextField = "Name"; ddlrole.DataValueField = "RoleId"; ddlrole.DataBind(); ddlrole.Items.Insert(0, common.AddItemToList("All", "")); } }
private void sendEmail(String _estNum, String filenm, String IsFinancial) { Whitfieldcore _wcore = new Whitfieldcore(); whitfielduser _wuser = new whitfielduser(); using (DataSet dsContacts = _wcore.GetContactsForProject(Convert.ToInt32(_estNum))) { DataTable dtContacts = dsContacts.Tables[0]; if (dtContacts.Rows.Count > 0) { foreach (DataRow dRow in dtContacts.Rows) { String _contactNm = dRow["contactName"] == DBNull.Value ? " " : dRow["contactName"].ToString(); String _contactEmail = dRow["email"] == DBNull.Value ? " " : dRow["email"].ToString(); String _clientnm = dRow["Name"] == DBNull.Value ? " " : dRow["Name"].ToString(); String _contactNumber = _wuser.GetContactNo(prjEsti); String mode = ""; if (IsFinancial == "Y") { mode = "Proposal"; } else { mode = "Scope"; } //HHS Uncomment this portion when there is an email list. MailMessage message = new MailMessage(); //message.To.Add(System.Configuration.ConfigurationManager.AppSettings["devEmail"]); //message.To.Add(System.Configuration.ConfigurationManager.AppSettings["AdminEmail"].ToString()); message.To.Add(_contactEmail); //This will be added once JW oks the function message.To.Add(System.Configuration.ConfigurationManager.AppSettings["EstimatingEmail"].ToString()); //This is tested for contact Email, remove once JW oks the function. message.From = new MailAddress(System.Configuration.ConfigurationManager.AppSettings["EstimatingEmail"]); message.Subject = txtprjname + " Architectural Millwork - WhitfieldCo - " + mode; message.IsBodyHtml = true; StringBuilder sb = new StringBuilder(); sb.Append("<html><head></head>"); sb.Append("<body>"); sb.Append("<TABLE cellSpacing='0' cellPadding='0' width='100%' border='0'><TR>"); sb.Append("<TD>"); sb.Append(_contactNm.Replace(",", " ") + ",<br>"); sb.Append("<br>Thank you for the opportunity to provide pricing on the " + txtprjname + " project for " + _clientnm + ". <br>"); sb.Append("<br>Please find attached our " + mode + " for the Custom Architectural Millwork which includes a complete and comprehensive scope for this work.<br>"); sb.Append("<br>You may contact me at " + _contactNumber + " with any questions regarding this estimate.<br>"); //sb.Append(<br>"_wuser.GetEstimatorName(prjEsti)); sb.Append("<br>" + txtNotes); sb.Append("<br><br>" + _wuser.GetEstimatorName(prjEsti) + ",<br>"); sb.Append("Estimator"); sb.Append("<br><br>"); sb.Append("</TD>"); sb.Append("</TR></TABLE>"); //Footer sb.Append("<TABLE cellSpacing='0' cellPadding='0' width='100%' border='0'><TR>"); sb.Append("<TD><IMG height='80' alt='' src='http://www.whitfield-co.com/whitfield-co/assets/img/TWC%20Primary%20Logo1.JPG' border='0'></TD></TR>"); sb.Append("<TR><TD class='form1' vAlign='bottom' align='left' width='100%'><b>The Whitfield Co., Inc.<br>"); sb.Append("8836 Washington Blvd., Ste 101<br>"); sb.Append("Jessup, MD 20794<br>"); sb.Append("(301)-483-0791<br>"); sb.Append("(301)-483-0792<br>"); sb.Append("http://www.whitfield-co.com<br>"); sb.Append("<IMG height='9' alt='' src='http://www.whitfield-co.com/whitfield-co/assets/img/images.gif' width='1'>"); sb.Append("</TD>"); sb.Append("</TR></TABLE>"); sb.Append("</body></html>"); message.Body = sb.ToString(); message.Attachments.Add(new System.Net.Mail.Attachment(HttpContext.Current.Server.MapPath("~/attachments/") + filenm)); SmtpClient smtp = new SmtpClient(System.Configuration.ConfigurationManager.AppSettings["smtp"]); smtp.Send(message); if (!_contactEmail.Equals("")) { _wcore.InsertEmailConversation(Convert.ToInt32(_estNum), _contactEmail, _contactNm, DateTime.Now.ToString("MM-dd-yyyy"), DateTime.Now.ToString("T"), mode); } } } } }
private DataSet Summary_Queue() { DataSet dsRpAdvances = new DataSet(); try { whitfielduser Wuser = new whitfielduser(); dsRpAdvances = Wuser.SearchUserRecord(txtuserid.Text.Trim(),txtfn.Text.Trim(),txtln.Text.Trim(),ddlrole.SelectedItem.Value,txtphno.Text.Trim()); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } return dsRpAdvances; }