/// <summary>
/// Creates a new instance of the Qds_PaymentMethodAvailableByDepot class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Qds_PaymentMethodAvailableByDepot MakeQds_PaymentMethodAvailableByDepot(SqlDataReader dataReader)
{
Qds_PaymentMethodAvailableByDepot qds_PaymentMethodAvailableByDepot = new Qds_PaymentMethodAvailableByDepot();
qds_PaymentMethodAvailableByDepot.DepotID = SqlClientUtility.GetString(dataReader, "DepotID", String.Empty);
qds_PaymentMethodAvailableByDepot.PaymentMethodID = SqlClientUtility.GetInt32(dataReader, "PaymentMethodID", 0);
qds_PaymentMethodAvailableByDepot.DepotDefault = SqlClientUtility.GetBoolean(dataReader, "DepotDefault", false);
return(qds_PaymentMethodAvailableByDepot);
}
/// <summary>
/// Updates a record in the Qds_PaymentMethodAvailableByDepot table.
/// </summary>
public virtual void Update(Qds_PaymentMethodAvailableByDepot qds_PaymentMethodAvailableByDepot)
{
ValidationUtility.ValidateArgument("qds_PaymentMethodAvailableByDepot", qds_PaymentMethodAvailableByDepot);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@DepotID", qds_PaymentMethodAvailableByDepot.DepotID),
new SqlParameter("@PaymentMethodID", qds_PaymentMethodAvailableByDepot.PaymentMethodID),
new SqlParameter("@DepotDefault", qds_PaymentMethodAvailableByDepot.DepotDefault)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Qds_PaymentMethodAvailableByDepot_Update", parameters);
}
/// <summary>
/// Selects all records from the Qds_PaymentMethodAvailableByDepot table.
/// </summary>
public virtual List <Qds_PaymentMethodAvailableByDepot> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Qds_PaymentMethodAvailableByDepot_SelectAll"))
{
List <Qds_PaymentMethodAvailableByDepot> qds_PaymentMethodAvailableByDepotList = new List <Qds_PaymentMethodAvailableByDepot>();
while (dataReader.Read())
{
Qds_PaymentMethodAvailableByDepot qds_PaymentMethodAvailableByDepot = MakeQds_PaymentMethodAvailableByDepot(dataReader);
qds_PaymentMethodAvailableByDepotList.Add(qds_PaymentMethodAvailableByDepot);
}
return(qds_PaymentMethodAvailableByDepotList);
}
}
/// <summary>
/// Selects all records from the Qds_PaymentMethodAvailableByDepot table by a foreign key.
/// </summary>
public virtual List <Qds_PaymentMethodAvailableByDepot> _SelectAllByPaymentMethodID(int paymentMethodID)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@PaymentMethodID", paymentMethodID)
};
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Qds_PaymentMethodAvailableByDepot_SelectAllByPaymentMethodID", parameters))
{
List <Qds_PaymentMethodAvailableByDepot> qds_PaymentMethodAvailableByDepotList = new List <Qds_PaymentMethodAvailableByDepot>();
while (dataReader.Read())
{
Qds_PaymentMethodAvailableByDepot qds_PaymentMethodAvailableByDepot = MakeQds_PaymentMethodAvailableByDepot(dataReader);
qds_PaymentMethodAvailableByDepotList.Add(qds_PaymentMethodAvailableByDepot);
}
return(qds_PaymentMethodAvailableByDepotList);
}
}
private int NextPaymentMethodID()
{
//
if (qds_PaymentMethod_Sp == null)
{
qds_PaymentMethod_Sp = new Qds_PaymentMethod_Sp(Properties.Settings.Default.WsirDbConnectionString);
}
List <Qds_PaymentMethod> qds_PaymentMethodList = qds_PaymentMethod_Sp.SelectAll();
if (qds_PaymentMethodList.Count < 1)
{
return(-1);
}
if (qds_PaymentMethodAvailableByDepot_Sp == null)
{
qds_PaymentMethodAvailableByDepot_Sp = new Qds_PaymentMethodAvailableByDepot_Sp(Properties.Settings.Default.WsirDbConnectionString);
}
foreach (Qds_PaymentMethod pm in qds_PaymentMethodList)
{
if (pm.PaymentMethodID == 0)
{
continue;
}
qds_PaymentMethodAvailableByDepot = qds_PaymentMethodAvailableByDepot_Sp.Select(depotID, pm.PaymentMethodID);
if (qds_PaymentMethodAvailableByDepot == null)
{
return(pm.PaymentMethodID);
}
}
return(-1);
}
private void OK_Click(object sender, EventArgs e)
{
if (DataGridView1.Rows.Count < 1)
{
return;
}
int paymentMethodID = (int)DataGridView1.CurrentRow.Cells[1].Value;
if (paymentMethodID == 0)
{
MessageBox.Show("Please select another method!");
return;
}
//Check that PaymentMethod is not assigned if change
if (formerPaymentMethodID != paymentMethodID)
{
if (qds_PaymentMethodAvailableByDepot_Sp == null)
{
qds_PaymentMethodAvailableByDepot_Sp = new Qds_PaymentMethodAvailableByDepot_Sp(Properties.Settings.Default.WsirDbConnectionString);
}
qds_PaymentMethodAvailableByDepot = qds_PaymentMethodAvailableByDepot_Sp.Select(depotID, paymentMethodID);
if (qds_PaymentMethodAvailableByDepot != null)
{
MessageBox.Show("Payment Method already assigned!");
return;
}
}
//only on DepotDefault
bool depotDefault = (bool)DataGridView1.CurrentRow.Cells[2].Value;
if (depotDefault &&
(formerDepotDefault != depotDefault))
{
using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.WsirDbConnectionString))
{
try
{
string query =
"UPDATE [Qds_PaymentMethodAvailableByDepot] WITH (ROWLOCK) " +
"SET [DepotDefault] = 0 " +
"WHERE [DepotID] = '" + depotID + "' ";
using (SqlCommand command = new SqlCommand(query, connection))
{
connection.Open();
command.ExecuteNonQuery();
}
}
catch
{
//
}
finally
{
connection.Close();
}
}
}
if (OK.Text == "&Select")
{
try
{
int.TryParse(this.DataGridView1.CurrentRow.Cells[0].Value.ToString(), out fieldId);
if (fieldId < 1)
{
throw new Exception();
}
fieldName = DataGridView1.CurrentRow.Cells[1].Value.ToString().Trim();
}
catch
{
MessageBox.Show("Please select a valid item.");
return;
}
Close();
return;
}
BindingNavigatorSaveItem.PerformClick();
}