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