private void deleteBank()
{
if (this.dvBanks.Count > 0)
{
BindingManagerBase bm = (BindingManagerBase)this.BindingContext[this.dvBanks];
BPS.BLL.Bank.DataSets.dsBanks.BanksRow rw = (BPS.BLL.Bank.DataSets.dsBanks.BanksRow)((DataRowView)bm.Current).Row;
if (MsgBoxX.Show("Вы действительно хотите удалить банк " + rw.BankName + "?", "BPS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
((DataRowView)bm.Current).Delete();
bllBank.Update();
}
}
}
public EditBank(BPS.BLL.Bank.DataSets.dsBanks.BanksRow rw, BPS.BLL.City.coCities bll)
{
drowBank = rw;
//
// Required for Windows Form Designer support
//
InitializeComponent();
bllCity = bll;
this.dsCities1 = bllCity.DataSet;
this.dvCities.Table = this.dsCities1.Cities;
this.dvCities.Sort = "CityName";
}
public static bool AddBankDialog(BPS.BLL.Bank.coBanks bll, BPS.BLL.City.coCities bllC)
{
BPS.BLL.Bank.DataSets.dsBanks.BanksRow rw = bll.DataSet.Banks.NewBanksRow();
EditBank eb = new EditBank(rw, bllC);
eb.ShowDialog();
if (eb.DialogResult == DialogResult.OK)
{
bll.DataSet.Banks.AddBanksRow(rw);
bll.Update();
return(true);
}
return(false);
}
private void editBank()
{
if (!this.toolBarButton2.Enabled)
{
return;
}
if (this.dvBanks.Count > 0)
{
BindingManagerBase bm = (BindingManagerBase)this.BindingContext[this.dvBanks];
BPS.BLL.Bank.DataSets.dsBanks.BanksRow rw = (BPS.BLL.Bank.DataSets.dsBanks.BanksRow)((DataRowView)bm.Current).Row;
EditBank eb = new EditBank(rw, this.bllCity);
eb.ShowDialog();
if (eb.DialogResult == DialogResult.OK)
{
bllBank.Update();
}
}
}
private void selectBank(bool isNew)
{
if (isNew)
{
BPS.BLL.Bank.DataSets.dsBanks.BanksRow rw = this.bllBank.DataSet.Banks.NewBanksRow();
rw.BankName = this.rwReq.BankName;
rw.CodeBIK = this.rwReq.CodeBIK;
BPS.Forms.Bank.EditBank eb = new BPS.Forms.Bank.EditBank(rw, this.bllCity);
eb.ShowDialog();
if (eb.DialogResult == DialogResult.OK)
{
iBankID = bllBank.AddBank(rw);
}
/*
* AddBankForClientRequest ab = new AddBankForClientRequest();
* ab.BankName = this.rwReq.BankName;
* ab.BIK = this.rwReq.CodeBIK;
* ab.ShowDialog();
* string szKAccount = "";
* int iCityID = 0;
* if(ab.DialogResult == DialogResult.OK)
* {
* szKAccount = ab.KAccount;
* iCityID = ab.CityID;
* this.rwReq.CodeBIK = ab.BIK;
* }
* else
* {
* this.iBankID = 0;
* return;
* }
* SqlCommand cmdInsBank = new SqlCommand("[InsertBank]", this.sqlConnection1);
* cmdInsBank.CommandType = CommandType.StoredProcedure;
* cmdInsBank.Parameters.Add(new SqlParameter("@OrgAccountID", SqlDbType.Int));
* cmdInsBank.Parameters.Add(new SqlParameter("@BankName", SqlDbType.NVarChar));
* cmdInsBank.Parameters.Add(new SqlParameter("@CodeBIK", SqlDbType.NVarChar));
* cmdInsBank.Parameters.Add(new SqlParameter("@BankID", SqlDbType.Int));
* cmdInsBank.Parameters.Add(new SqlParameter("@KAccount", SqlDbType.NVarChar));
* cmdInsBank.Parameters.Add(new SqlParameter("@CityID", SqlDbType.Int));
* cmdInsBank.Parameters["@BankID"].Direction = ParameterDirection.Output;
* cmdInsBank.Parameters["@OrgAccountID"].Value = this.iOrgAccountID;
* cmdInsBank.Parameters["@BankName"].Value = this.rwReq.BankName;
* cmdInsBank.Parameters["@CodeBIK"].Value = this.rwReq.CodeBIK;
* cmdInsBank.Parameters["@KAccount"].Value = szKAccount;
* cmdInsBank.Parameters["@CityID"].Value = iCityID;
* this.sqlConnection1.Open();
* try
* {
* cmdInsBank.ExecuteNonQuery();
* object o = cmdInsBank.Parameters["@BankID"].Value;
* if(o != Convert.DBNull)
* this.iBankID = Convert.ToInt32(o);
* else this.iBankID = 0;
* }
* catch
* {
* this.iBankID = 0;
* }
* finally
* {
* this.sqlConnection1.Close();
* }
*/
}
else
{
if (this.dvBanks.Count > 0)
{
BindingManagerBase bm = (BindingManagerBase)this.BindingContext[this.dvBanks];
this.iBankID = Convert.ToInt32(this.dvBanks[bm.Position]["BankID"]);
this.rwReq.CodeBIK = this.dvBanks[bm.Position]["CodeBIK"].ToString();
this.rwReq.BankName = this.dvBanks[bm.Position]["BankName"].ToString();
}
else
{
this.iBankID = 0;
}
}
}
