public void AddNewUserCompany(Entities.User user)
{
try
{
SharepointHelper spHelper = new SharepointHelper(Web);
SPList list = spHelper.GetListItems("UserCompanyNew");
SPListItem newItem = list.Items.Add();
newItem["SecondName"] = user.SecondName;
newItem["SecondSurname"] = user.SecondSurname;
newItem["FirstName"] = user.FirstName;
newItem["FirstSurname"] = user.FirstSurname;
newItem["NIT"] = user.NIT;
newItem["SubNIT"] = user.SubNIT;
newItem["Company"] = user.Company;
newItem["IdentificationNumber"] = user.IdentificationNumber;
newItem["IdentificationType"] = user.IdentificationType;
newItem["Ocupattion"] = user.Ocupattion;
newItem["CompanyEmail"] = user.CompanyEmail;
newItem["CompanyMobile"] = user.CompanyMobile;
newItem["CompanyTel"] = user.CompanyTel;
newItem["TelExtension"] = user.TelExtension;
newItem["PersonalManager"] = user.PersonalManager;
newItem.Update();
}
catch (Exception ex)
{
throw ex;
}
}
public SPList GetIdentificationTypeSPList()
{
try
{
SharepointHelper SPHelpter = new SharepointHelper(Web);
return SPHelpter.GetListItems("IdentificationType");
}
catch (Exception ex)
{
throw ex;
}
}
public bool ExistsIdentificationInList(string identificationType, string identificationNumber)
{
try
{
SharepointHelper SPHelper = new SharepointHelper(Web);
SPList list = SPHelper.GetListItems("UserCompanyNew");
SPQuery query = new SPQuery();
query.Query = string.Format("<Where><And><Eq><FieldRef Name='IdentificationType'/><Value Type='Text'>{0}</Value></Eq><Eq><FieldRef Name='IdentificationNumber'/><Value Type='Text'>{1}</Value></Eq></And></Where>", identificationType, identificationNumber);
return (list.GetItems(query).Count > 0);
}
catch (Exception ex)
{
throw ex;
}
}
public bool ExistsCompanyInList(string nit, string subnit)
{
try
{
SharepointHelper SPHelper = new SharepointHelper(Web);
SPList list = SPHelper.GetListItems("UserCompanyNew");
SPQuery query = new SPQuery();
query.Query = string.Format("<Where><And><Eq><FieldRef Name='NIT'/><Value Type='Text'>{0}</Value></Eq><Eq><FieldRef Name='SubNIT'/><Value Type='Text'>{1}</Value></Eq></And></Where>", nit, subnit);
return (list.GetItems(query).Count > 0);
}
catch (Exception ex)
{
throw ex;
}
}