private void InsertBanksSQL(BancosSAT BS, Form Prin)
{
using (SqlConnection con = ConexionSQL.Cadenaconexion("ATX_POS"))
{
con.Open();
SqlCommand command = new SqlCommand();
command.Parameters.Clear();
command.Connection = con;
command.CommandText = ("Select Codebank from BankSAT where Codebank = @CodeBankNav");
command.Parameters.AddWithValue("@CodeBankNav", BS.Code.ToString());
int Exist = Convert.ToInt32(command.ExecuteScalar());
if (Exist == 0)
{
command.Parameters.Clear();
command.CommandText = ("Insert into BankSAT(Name,CodeBank,DatePosted) values(@NameBankNav, @CodeBankSATNav,@DatePosted)");
command.Parameters.AddWithValue("@CodeBankSATNav", BS.Code.ToString());
command.Parameters.AddWithValue("@DatePosted", DateWork);
command.Parameters.AddWithValue("@NameBankNav", BS.Name.ToString());
command.ExecuteScalar();
}
else if (Exist != 0)
{
DialogResult result;
result = MessageBox.Show("El Registro ya existe en la base"
+ System.Environment.NewLine
+ "¿Desea Actualizarlo?", "Registro Duplicado", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
command.Parameters.Clear();
command.CommandText = ("UPDATE BankSAT set Name = @NameBankNav, CodeBank = @CodeBankSATNav, LastModify = @DateModify where CodeBank = @CodeBankSATNav");
command.Parameters.AddWithValue("@CodeBankSATNav", BS.Code.ToString());
command.Parameters.AddWithValue("@DateModify", DateWork);
command.Parameters.AddWithValue("@NameBankNav", BS.Name.ToString());
command.ExecuteScalar();
}
}
con.Close();
}
}
static string GetBank(BancosSAT BS)
{
return("Nombre Banco: " + BS.Name);
}
