//Extrae los datos de la BdD
private void Commands()
{
InsertFirmRole objFirmRole = InsertFirmRoleBL.InsertFirmRole(txtFirm.Text, txtPCC.Text, rolename);
if (objFirmRole == null)
{
MessageBox.Show("EL ROL DE FIRMA HA SIDO CREADO", Resources.Constants.MYCTS, MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbRole.Focus();
}
else if (objFirmRole.Exist == false)
{
MessageBox.Show("EL ROL DE FIRMA YA EXISTE", Resources.Constants.MYCTS, MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbRole.Focus();
}
}
public InsertFirmRole InsertFirmRole(string Firm, string Pcc, string RoleName, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbcommand = db.GetStoredProcCommand(Resources.InsertFirmRoleResources.SP_InsertFirmRole);
db.AddInParameter(dbcommand, Resources.InsertFirmRoleResources.PARAM_QUERY, DbType.String, Firm);
db.AddInParameter(dbcommand, Resources.InsertFirmRoleResources.PARAM_QUERY1, DbType.String, Pcc);
db.AddInParameter(dbcommand, Resources.InsertFirmRoleResources.PARAM_QUERY2, DbType.String, RoleName);
InsertFirmRole item = null;
using (IDataReader dr = db.ExecuteReader(dbcommand))
{
if (dr.Read())
{
item = new InsertFirmRole();
}
}
return(item);
}
public static InsertFirmRole InsertFirmRole(string Firm, string Pcc, string RoleName)
{
InsertFirmRole insertFirmRole = new InsertFirmRole();
InsertFirmRoleDAL objFirmRole = new InsertFirmRoleDAL();
try
{
insertFirmRole = objFirmRole.InsertFirmRole(Firm, Pcc, RoleName, CommonENT.MYCTSDBSECURITY_CONNECTION);
}
catch (Exception ex)
{
new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos);
try
{
insertFirmRole = objFirmRole.InsertFirmRole(Firm, Pcc, RoleName, CommonENT.MYCTSDBSECURITYBACKUP_CONNECTION);
}
catch
{
insertFirmRole.Exist = false;
}
}
return(insertFirmRole);
}
