private void cbxContactRole_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (cbxContactRole.SelectedItem != null)
{
contact_role contact_role = cbxContactRole.SelectedItem as contact_role;
if (contact_role.is_principal == true)
{
cbxRelation.IsEnabled = false;
}
else
{
cbxRelation.IsEnabled = true;
}
if (contact_role.can_transact == true)
{
tabFinance.Visibility = Visibility.Visible;
//tabSubscription.Visibility = Visibility.Visible;
}
else
{
tabFinance.Visibility = Visibility.Collapsed;
//tabSubscription.Visibility = Visibility.Collapsed;
}
}
}
private void btnNew_Click(object sender, RoutedEventArgs e)
{
crud_modal.Visibility = Visibility.Visible;
cntrl.Curd.Contact_Role objcontact_role = new cntrl.Curd.Contact_Role();
contact_role contact_role = new contact_role();
entity.db.contact_role.Add(contact_role);
contact_roleViewSource.View.MoveCurrentToLast();
objcontact_role.objCollectionViewSource = contact_roleViewSource;
objcontact_role.entity = entity;
crud_modal.Children.Add(objcontact_role);
}
private void sync_ContactRole()
{
using (db db = new db())
{
contact_role contact_role = new contact_role();
contact_role.id_company = id_company;
contact_role.is_active = true;
contact_role.is_principal = true;
contact_role.can_transact = true;
contact_role.name = "Contacto Principal";
db.contact_role.Add(contact_role);
db.SaveChanges();
}
if (_connString.Contains("Angelius"))
{
SqlConnection conn = new SqlConnection(_connString);
string sql = "SELECT CUSTOMFIELD FROM dbo.CLIENTES GROUP BY CUSTOMFIELD ORDER BY CUSTOMFIELD DESC";
DataTable dt_customer = exeDT(sql);
foreach (DataRow item in dt_customer.Rows)
{
if (Regex.IsMatch(item[0].ToString(), @"^[a-zA-Z]+$"))
{
using (db db = new db())
{
contact_role contact_role = new contact_role();
contact_role.id_company = id_company;
contact_role.is_active = true;
contact_role.is_principal = false;
contact_role.can_transact = false;
contact_role.name = item[0].ToString();
db.contact_role.Add(contact_role);
db.SaveChanges();
}
}
}
}
}
