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