/// <summary>
/// Creates a new instance of the Qds_PaymentMethod class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Qds_PaymentMethod MakeQds_PaymentMethod(SqlDataReader dataReader)
{
Qds_PaymentMethod qds_PaymentMethod = new Qds_PaymentMethod();
qds_PaymentMethod.PaymentMethodID = SqlClientUtility.GetInt32(dataReader, "PaymentMethodID", 0);
qds_PaymentMethod.PaymentMethod = SqlClientUtility.GetString(dataReader, "PaymentMethod", String.Empty);
return(qds_PaymentMethod);
}
/// <summary>
/// Saves a record to the Qds_PaymentMethod table.
/// </summary>
public virtual void Insert(Qds_PaymentMethod qds_PaymentMethod)
{
ValidationUtility.ValidateArgument("qds_PaymentMethod", qds_PaymentMethod);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@PaymentMethod", qds_PaymentMethod.PaymentMethod)
};
qds_PaymentMethod.PaymentMethodID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "Qds_PaymentMethod_Insert", parameters);
}
/// <summary>
/// Updates a record in the Qds_PaymentMethod table.
/// </summary>
public virtual void Update(Qds_PaymentMethod qds_PaymentMethod)
{
ValidationUtility.ValidateArgument("qds_PaymentMethod", qds_PaymentMethod);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@PaymentMethodID", qds_PaymentMethod.PaymentMethodID),
new SqlParameter("@PaymentMethod", qds_PaymentMethod.PaymentMethod)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Qds_PaymentMethod_Update", parameters);
}
/// <summary>
/// Selects all records from the Qds_PaymentMethod table.
/// </summary>
public virtual List <Qds_PaymentMethod> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Qds_PaymentMethod_SelectAll"))
{
List <Qds_PaymentMethod> qds_PaymentMethodList = new List <Qds_PaymentMethod>();
while (dataReader.Read())
{
Qds_PaymentMethod qds_PaymentMethod = MakeQds_PaymentMethod(dataReader);
qds_PaymentMethodList.Add(qds_PaymentMethod);
}
return(qds_PaymentMethodList);
}
}
private void ReadDrops(bool MineOnly)
{
listViewDrops.Items.Clear();
string orderType = String.Empty;
if (checkBoxMissingBags.Checked)
{
orderType = "M";
}
else
{
orderType = "Q";
}
//qds_DropList = qds_Drop_Sp.SelectAllInProcess();
qds_DropList = qds_Drop_Sp.SelectAllByOrderTpe(orderType);
if (qds_DropList != null)
{
if (buttonBags.Text == "&Unselect all")
{
buttonBags.Text = "&Select all";
}
}
Guid UserId = new Guid();
if (MineOnly)
{
if (sol_Order_Sp == null)
{
sol_Order_Sp = new Sol_Order_Sp(Properties.Settings.Default.WsirDbConnectionString);
}
MembershipUser UserAccount = Membership.GetUser();
UserId = (Guid)UserAccount.ProviderUserKey;
}
//dropID
//customer
//bags
//paymentMethod
//depotID
//orderID
foreach (Qds_Drop or in qds_DropList)
{
if (MineOnly)
{
//is not user's order if does not exist
if (or.OrderID < 1)
{
continue;
}
sol_Order = sol_Order_Sp.Select(or.OrderID, or.OrderType);
//is not user's order if does not exist
if (sol_Order == null)
{
continue;
}
if (UserId != null)
{
if (UserId != sol_Order.UserID)
{
continue;
}
}
}
int dropID = or.DropID;
string customer = or.CustomerID.ToString();
sol_Customer = sol_Customer_Sp.Select(or.CustomerID);
if (sol_Customer != null)
{
customer = sol_Customer.Name;
}
int bags = or.NumberOfBags;
string paymentMethod = or.PaymentMethodID.ToString();
qds_PaymentMethod = qds_PaymentMethod_Sp.Select(or.PaymentMethodID);
if (qds_PaymentMethod != null)
{
paymentMethod = qds_PaymentMethod.PaymentMethod;
}
string depotID = or.DepotID;
int orderID = or.OrderID;
addDropItem(dropID, customer, bags, paymentMethod, depotID, orderID, or.OrderType);
}
}
