/// <summary>
/// Creates a new instance of the sol_CashTrays class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_CashTray MakeSol_CashTray(SqlDataReader dataReader)
{
Sol_CashTray sol_CashTray = new Sol_CashTray();
sol_CashTray.CashTrayID = SqlClientUtility.GetInt32(dataReader, "CashTrayID", 0);
sol_CashTray.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
sol_CashTray.WorkStationID = SqlClientUtility.GetInt32(dataReader, "WorkStationID", 0);
sol_CashTray.UserID = SqlClientUtility.GetGuid(dataReader, "UserID", Guid.Empty);
sol_CashTray.UserName = SqlClientUtility.GetString(dataReader, "UserName", String.Empty);
return(sol_CashTray);
}
/// <summary>
/// Saves a record to the sol_CashTrays table.
/// </summary>
public virtual void Insert(Sol_CashTray sol_CashTray)
{
ValidationUtility.ValidateArgument("sol_CashTray", sol_CashTray);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Description", sol_CashTray.Description),
new SqlParameter("@WorkStationID", sol_CashTray.WorkStationID),
new SqlParameter("@UserID", sol_CashTray.UserID),
new SqlParameter("@UserName", sol_CashTray.UserName)
};
sol_CashTray.CashTrayID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "sol_CashTrays_Insert", parameters);
}
/// <summary>
/// Selects all records from the sol_CashTrays table.
/// </summary>
public virtual List <Sol_CashTray> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "sol_CashTrays_SelectAll"))
{
List <Sol_CashTray> sol_CashTrayList = new List <Sol_CashTray>();
while (dataReader.Read())
{
Sol_CashTray sol_CashTray = MakeSol_CashTray(dataReader);
sol_CashTrayList.Add(sol_CashTray);
}
return(sol_CashTrayList);
}
}
private bool addItem(int orderNumber, decimal amount, string station, string employee,
/*string openTime,*/
string submitDate,
bool select, string orderType, decimal fee, string status, int cashTrayID, DateTime datePaid, string reference, DateTime date)
{
string[] str = new string[14];
ListViewItem itm = new ListViewItem();
//formatting numbers
string c = String.Format("{0,8:#,##0.00}", amount);
if (orderType == "R")
{
c = String.Format("{0,8:(#,##0.00)}", amount);
}
int index = 0;
//0
str[index++] = Funciones.Indent(7) + String.Format("{0,3:##000}", orderNumber);
//1
str[index++] = c; //String.Format("{0,8:$#,##0.00;($#,##0.00)}", amount);
//2
str[index++] = station;
//3
str[index++] = employee;
//4
str[index++] = orderType;
c = String.Format("{0,8:#,##0.00}", fee);
//5
str[index++] = c; //String.Format("{0,8:$#,##0.00;($#,##0.00)}", fee);
//
//str[index++] = openTime;
//6
str[index++] = submitDate;
//7
str[index++] = Main.returnOrderStatusType.SingleOrDefault(p => p.Id == status).Description;
Sol_CashTray sol_CashTray = sol_CashTray_Sp.Select(cashTrayID);
//8
if (sol_CashTray == null)
{
str[index++] = "";
}
else
{
str[index++] = sol_CashTray.Description;
}
//9
if (datePaid < date)
{
str[index++] = "";
}
else
{
str[index++] = datePaid.ToShortDateString();
}
str[index++] = reference;
itm = new ListViewItem(str);
itm.Checked = select;
if (!String.IsNullOrEmpty(str[9])) //date paid
{
itm.BackColor = System.Drawing.SystemColors.Control;
}
listView1.Items.Add(itm);
return(true);
}
