/// <summary>
/// Selects all records from the Qds_Bag table.
/// </summary>
public virtual List <Qds_Bag> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Qds_Bag_SelectAll"))
{
List <Qds_Bag> qds_BagList = new List <Qds_Bag>();
while (dataReader.Read())
{
Qds_Bag qds_Bag = MakeQds_Bag(dataReader);
qds_BagList.Add(qds_Bag);
}
return(qds_BagList);
}
}
/// <summary>
/// Creates a new instance of the Qds_Bag class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Qds_Bag MakeQds_Bag(SqlDataReader dataReader)
{
Qds_Bag qds_Bag = new Qds_Bag();
qds_Bag.BagID = SqlClientUtility.GetInt32(dataReader, "BagID", 0);
qds_Bag.DropID = SqlClientUtility.GetInt32(dataReader, "DropID", 0);
qds_Bag.BagEstimateUnderLitre = SqlClientUtility.GetInt32(dataReader, "BagEstimateUnderLitre", 0);
qds_Bag.BagEstimateOverLitre = SqlClientUtility.GetInt32(dataReader, "BagEstimateOverLitre", 0);
qds_Bag.DateEntered = SqlClientUtility.GetDateTime(dataReader, "DateEntered", DateTime.Now);
qds_Bag.DateAccepted = SqlClientUtility.GetDateTime(dataReader, "DateAccepted", DateTime.Now);
qds_Bag.DateCounted = SqlClientUtility.GetDateTime(dataReader, "DateCounted", DateTime.Now);
qds_Bag.DatePaid = SqlClientUtility.GetDateTime(dataReader, "DatePaid", DateTime.Now);
qds_Bag.DepotID = SqlClientUtility.GetString(dataReader, "DepotID", String.Empty);
qds_Bag.DatePrinted = SqlClientUtility.GetDateTime(dataReader, "DatePrinted", DateTime.Now);
//qds_Bag.IsNew = SqlClientUtility.GetBoolean(dataReader, "IsNew", false);
return(qds_Bag);
}
/// <summary>
/// Selects all records from the Qds_Bag table by a foreign key.
/// </summary>
public virtual List <Qds_Bag> _SelectAllByDropID(int dropID)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@DropID", dropID)
};
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Qds_Bag_SelectAllByDropID", parameters))
{
List <Qds_Bag> qds_BagList = new List <Qds_Bag>();
while (dataReader.Read())
{
Qds_Bag qds_Bag = MakeQds_Bag(dataReader);
qds_BagList.Add(qds_Bag);
}
return(qds_BagList);
}
}
/// <summary>
/// Saves a record to the Qds_Bag table.
/// </summary>
public virtual void Insert(Qds_Bag qds_Bag)
{
ValidationUtility.ValidateArgument("qds_Bag", qds_Bag);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@DropID", qds_Bag.DropID),
new SqlParameter("@BagEstimateUnderLitre", qds_Bag.BagEstimateUnderLitre),
new SqlParameter("@BagEstimateOverLitre", qds_Bag.BagEstimateOverLitre),
new SqlParameter("@DateEntered", qds_Bag.DateEntered),
new SqlParameter("@DateAccepted", qds_Bag.DateAccepted),
new SqlParameter("@DateCounted", qds_Bag.DateCounted),
new SqlParameter("@DatePaid", qds_Bag.DatePaid),
new SqlParameter("@DepotID", qds_Bag.DepotID),
new SqlParameter("@DatePrinted", qds_Bag.DatePrinted)
//, new SqlParameter("@IsNew", qds_Bag.IsNew)
};
qds_Bag.BagID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "Qds_Bag_Insert", parameters);
}
public static void CompleteOrder(
int orderID
, string orderType
, ref List <int> listOfBagsCounted
, ref List <int> listOfBagsNotCounted
)
{
if (listOfBagsNotCounted.Count < 1)
{
return;
}
//set the status of the rest of the bags to MISSING
Qds_Drop_Sp qds_Drop_Sp = new Qds_Drop_Sp(Properties.Settings.Default.WsirDbConnectionString);
List <Qds_Drop> dl = qds_Drop_Sp._SelectAllByOrderID_OrderType(orderID, orderType);
Qds_Drop qds_Drop = dl[0];
Qds_Bag_Sp qds_Bag_Sp = new Qds_Bag_Sp(Properties.Settings.Default.WsirDbConnectionString);
List <Qds_Bag> bl = qds_Bag_Sp._SelectAllByDropID(qds_Drop.DropID);
//create new drop for missing bags
Qds_Drop nd = new Qds_Drop();
//nd.DropID = 0;
nd.CustomerID = qds_Drop.CustomerID;
nd.NumberOfBags = listOfBagsNotCounted.Count; // od.NumberOfBags;
nd.PaymentMethodID = qds_Drop.PaymentMethodID;
nd.DepotID = qds_Drop.DepotID;
nd.OrderID = 0;
nd.OrderType = "M"; //missing
qds_Drop_Sp.Insert(nd);
//move missing bags to new drop
//foreach(ComboBoxItem i in comboBoxBagId.Items)
foreach (int id in listOfBagsNotCounted)
{
//move missing bag
Qds_Bag mb = qds_Bag_Sp.Select(id); //bagIdFromComboBox);
mb.DropID = nd.DropID;
qds_Bag_Sp.Update(mb);
}
//change numer of bags of the original drop
qds_Drop.NumberOfBags -= listOfBagsNotCounted.Count();
qds_Drop_Sp.Update(qds_Drop);
//close order
Sol_Order_Sp sol_Order_Sp = new Sol_Order_Sp(Properties.Settings.Default.WsirDbConnectionString);
Sol_Order sol_Order = sol_Order_Sp.Select(orderID, orderType);
sol_Order_Sp.UpdateDates(sol_Order.OrderID, sol_Order.OrderType, "", "DateClosed");
//is drop ready for payment?
if (qds_Drop_Sp.IsReady(qds_Drop.DropID))
{
string status = String.Empty;
if (qds_Drop.PaymentMethodID == 1)
{
status = "A";
}
else
{
status = "O";
}
sol_Order_Sp.UpdateStatus(sol_Order.OrderID, sol_Order.OrderType, status);
}
//update customerID
//sol_Order_Sp._UpdateCustomerID(sol_Order.OrderID, sol_Order.OrderType, qds_Drop.CustomerID);
}
