public static bool CompanyExists(Guid organizationId, int BWAAccountID,
string name)
{
Company comp = new Company(organizationId);
comp.Where.Company_name.Value = name;
comp.Where.Company_name.Operator = NCI.EasyObjects.WhereParameter.Operand.Equal;
comp.Where.BWAAccountId.Value = BWAAccountID;
comp.Where.BWAAccountId.Operator = NCI.EasyObjects.WhereParameter.Operand.Equal;
comp.Query.Load();
return (comp.RowCount == 0 ? false : true);
}
// for external use - web service
public static DataSet GetCompanyData(Guid organizationId, int companyID)
{
Company comp = new Company(organizationId);
comp.Where.Company_id.Value = companyID;
comp.Where.Company_id.Operator = WhereParameter.Operand.Equal;
comp.Query.AddResultColumn(tbl_companySchema.BWAAccountId);
comp.Query.AddResultColumn(tbl_companySchema.BWADepartmentId);
comp.Query.AddResultColumn(tbl_companySchema.Company_name);
comp.Query.Load();
if (comp.DefaultView.Table.Rows.Count > 0)
{
DataSet ds = new DataSet();
ds.Tables.Add(comp.DefaultView.Table);
return ds;
}
return null;
}
public static int GetCompanyID(Guid organizationId, int BWAAccountID,
int BWADepartmentID,
string name)
{
Company comp = new Company(organizationId);
comp.Where.Company_name.Value = name;
comp.Where.Company_name.Operator = NCI.EasyObjects.WhereParameter.Operand.Equal;
comp.Where.BWAAccountId.Value = BWAAccountID;
comp.Where.BWAAccountId.Operator = NCI.EasyObjects.WhereParameter.Operand.Equal;
comp.Where.BWADepartmentId.Value = BWADepartmentID;
comp.Where.BWADepartmentId.Operator = NCI.EasyObjects.WhereParameter.Operand.Equal;
comp.Query.Load();
return (comp.RowCount == 0 ? 0 : comp.Company_id);
}