public void insertshift(string cbtt, string pcode, DateTime date_measured,
double? discharge, double? gage_height, double shift, string comments, DateTime date_entered)
{
string sql = "select * from shifts where 2=1";
shiftsDataTable tbl = new shiftsDataTable();
GetServer().FillTable(tbl, sql);
var row = tbl.NewshiftsRow();
//due to our Sequence in the Dbase the id is 0 here but will add 1 to last id in dbase
row.id = 0;
row.cbtt = cbtt.ToUpper();
row.pcode = pcode.ToUpper();
row.date_measured = date_measured;
if (discharge.HasValue)
{
row["discharge"] = discharge;
}
if (gage_height.HasValue)
{
row["stage"] = gage_height;
}
row.shift = shift;
row.comments = comments;
row.username = WindowsUtility.GetShortUserName().ToLower();
row.date_entered = date_entered;
tbl.AddshiftsRow(row);
GetServer().SaveTable(tbl);
}
public void insertshift(string cbtt, string pcode, DateTime date_measured,
double?discharge, double?gage_height, double shift, string comments, DateTime date_entered)
{
string sql = "select * from shifts where 2=1";
shiftsDataTable tbl = new shiftsDataTable();
GetServer().FillTable(tbl, sql);
var row = tbl.NewshiftsRow();
//due to our Sequence in the Dbase the id is 0 here but will add 1 to last id in dbase
row.id = 0;
row.cbtt = cbtt.ToUpper();
row.pcode = pcode.ToUpper();
row.date_measured = date_measured;
if (discharge.HasValue)
{
row["discharge"] = discharge;
}
if (gage_height.HasValue)
{
row["stage"] = gage_height;
}
row.shift = shift;
row.comments = comments;
row.username = WindowsUtility.GetShortUserName().ToLower();
row.date_entered = date_entered;
tbl.AddshiftsRow(row);
GetServer().SaveTable(tbl);
}
public shiftsDataTable GetDailyShifts(DateTime PreviousDay)
{
string sql = "select * from shifts where date_entered >'" + PreviousDay + "' order by date_entered";
shiftsDataTable tbl = new shiftsDataTable();
GetServer().FillTable(tbl, sql);
return tbl;
}
public shiftsDataTable GetDailyShifts(DateTime PreviousDay)
{
string sql = "select * from shifts where date_entered >'" + PreviousDay + "' order by date_entered";
shiftsDataTable tbl = new shiftsDataTable();
GetServer().FillTable(tbl, sql);
return(tbl);
}
public shiftsDataTable GetAllShifts()
{
string sql;
sql = "select * from shifts order by date_entered DESC, date_measured DESC";
shiftsDataTable tbl = new shiftsDataTable();
GetServer().FillTable(tbl, sql);
return tbl;
}
public shiftsDataTable GetAllShifts()
{
string sql;
sql = "select * from shifts order by date_entered DESC, date_measured DESC";
shiftsDataTable tbl = new shiftsDataTable();
GetServer().FillTable(tbl, sql);
return(tbl);
}
public shiftsDataTable GetShiftsTable(string cbtt="")
{
string sql;
if (cbtt == "ALL")
{
sql = "select * from shifts order by date_entered DESC, date_measured DESC";
}
else
{
sql = "select * from shifts where cbtt = '" + cbtt + "' order by date_entered DESC, date_measured DESC LIMIT 20";
}
shiftsDataTable tbl = new shiftsDataTable();
GetServer().FillTable(tbl, sql);
return tbl;
}
public shiftsDataTable GetShiftsTable(string cbtt = "")
{
string sql;
if (cbtt == "ALL")
{
sql = "select * from shifts order by date_entered DESC, date_measured DESC";
}
else
{
sql = "select * from shifts where cbtt = '" + cbtt + "' order by date_entered DESC, date_measured DESC LIMIT 20";
}
shiftsDataTable tbl = new shiftsDataTable();
GetServer().FillTable(tbl, sql);
return(tbl);
}
