private bool CheckforValidLogIn() { DataSet myDataset = new DataSet(); string sql; string passwordInDataBase = ""; sql = "Select password from employee where username = '******'"; myDataset = CCDAccess.SelectFromDB(sql); if ((myDataset != null)) { foreach (DataTable table in myDataset.Tables) { if (table.Rows.Count > 0) { DataRow d = table.Rows[0]; passwordInDataBase = d["password"].ToString(); } } } if (_passWord.Trim() == passwordInDataBase.Trim()) { return(true); } return(false); }
private List <string> GetDatabaseValues() { DataSet myDataset = new DataSet(); string sql; List <string> projectNumbers = new List <string>(); sql = "Select number from project "; myDataset = CCDAccess.SelectFromDB(sql); if ((myDataset != null)) { foreach (DataTable table in myDataset.Tables) { foreach (DataRow dr in table.Rows) { projectNumbers.Add(dr["number"].ToString()); } } } return(projectNumbers); //string additionalSpecification; //string lumbercode; //float bfPerPiece; //int stocked; //int transfer; //int auditWeek; //string includeInFifo; //string useAsStud; //int priority; //float freight; //string treated; //string oldLumberCode; //DateTime currentPriceDate; //float cost; //string useForRoofDesign; }
private string GetAllowedApps() { DataSet myDataset = new DataSet(); string sql; sql = "Select DotNetAppsAllowed from employee where username = '******'"; myDataset = CCDAccess.SelectFromDB(sql); if ((myDataset != null)) { foreach (DataTable table in myDataset.Tables) { if (table.Rows.Count > 0) { DataRow d = table.Rows[0]; return(d["DotNetAppsAllowed"].ToString()); } } } return(""); }
private Single GetCurrentLumberFactor() { DataSet myDataset = new DataSet(); string sql; sql = "Select * from variable where system = 'CCD' and variable = 'LumberPadFactor'"; myDataset = CCDAccess.SelectFromDB(sql); if ((myDataset != null)) { foreach (DataTable table in myDataset.Tables) { if (table.Rows.Count > 0) { DataRow d = table.Rows[0]; return(Convert.ToSingle(d["data"])); } } } return(0); }
private void GetDatabaseValues(string _passedLumberCode) { DataSet myDataset = new DataSet(); string sql; List <string> projectNumbers = new List <string>(); sql = "Select * from lumbertype where lumbercode = '" + _passedLumberCode + "'"; myDataset = CCDAccess.SelectFromDB(sql); if ((myDataset != null)) { foreach (DataTable table in myDataset.Tables) { foreach (DataRow dr in table.Rows) { _lumbercode = dr["lumbercode"].ToString(); _description = dr["description"].ToString(); _grade = dr["grade"].ToString(); _species = dr["species"].ToString(); _heightNominal = new Distance(new Inch(), Convert.ToDouble(dr["ThicknessN"].ToString())); _widthNominal = new Distance(new Inch(), Convert.ToDouble(dr["WidthN"].ToString())); _heightActual = new Distance(new Inch(), Convert.ToDouble(dr["ThicknessA"].ToString())); _widthActual = new Distance(new Inch(), Convert.ToDouble(dr["WidthA"].ToString())); _length = new Distance(new Inch(), Convert.ToDouble(dr["Length"].ToString())); _additionalSpecification = dr["AdditionalSpecifications"].ToString(); _bfPerPiece = Convert.ToSingle(dr["bfPerPiece"].ToString()); _stocked = dr["stocked"].ToString(); _useAsStud = dr["UseAsStud"].ToString(); _freight = Convert.ToSingle(dr["freight"].ToString()); _treated = dr["treated"].ToString(); } } } }
private LumberPrice GetLumberPrice(string _lumberCode, DateTime _inquiryDate) { DataSet myDataset = new DataSet(); string sql; sql = "Select * from lumberprices where lumbercode = '" + _lumberCode + "' and pricedate <= '" + _inquiryDate + "' order by pricedate desc"; myDataset = CCDAccess.SelectFromDB(sql); string _priceDate = ""; int _price = 0; Single _factor = 0; int _fobMillPrice = 0; int _freight = 0; LumberPrice tempLumberPrices; if ((myDataset != null)) { foreach (DataTable table in myDataset.Tables) { if (table.Rows.Count > 0) { DataRow d = table.Rows[0]; bool validData = true; if (d["PriceDate"] == DBNull.Value) { validData = false; } else { _priceDate = d["PriceDate"].ToString(); } if (d["Price"] == DBNull.Value) { validData = false; } else { _price = Convert.ToInt16(d["Price"]); } if (d["Factor"] == DBNull.Value) { validData = false; } else { _factor = Convert.ToSingle(d["Factor"]); } if (d["FobMillPrice"] == DBNull.Value) { _fobMillPrice = 0; } else { _fobMillPrice = Convert.ToInt16(d["FobMillPrice"]); } if (d["Freight"] == DBNull.Value) { _freight = 0; } else { _freight = Convert.ToInt16(d["Freight"]); } if (validData) { tempLumberPrices = new LumberPrice(_lumberCode, _priceDate, _price, _factor, _fobMillPrice, _freight); } else { tempLumberPrices = new LumberPrice(); } return(tempLumberPrices); } } } return(new LumberPrice()); }