public IHttpActionResult Post(Employed employed)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_repository.Create(employed);
return(CreatedAtRoute("DefaultApi", new { Id = employed.Id }, employed));
}
public void Update(Employed employed)
{
db.Entry(employed).State = EntityState.Modified;
try
{
db.SaveChanges();
}catch (DbUpdateConcurrencyException)
{
throw;
}
}
public bool ExistEmployedDuplicate(int iIdEmployed, String sEMail, int iNumber)
{
Employed a = new Employed();
if (a.getCountEmployedDuplicate(iIdEmployed, sEMail, iNumber) > 0)
{
return(true);
}
else
{
return(false);
}
}
public void getEmployees(ApplicationDbContext _context)
{
var emp = from r in _context.Users select r;
var listEmp = emp.ToList();
foreach (var Data in listEmp)
{
Employed.Add(new SelectListItem()
{
Value = Data.Id,
Text = Data.name
});
}
}
public bool ExistEmployed(int iNumEmp, string sMail)
{
var chocorroles = new Employed();
var swap = chocorroles.getAll();
var qbo = (from s in swap where s.iNumber.Equals(iNumEmp) || s.sEMail.Equals(sMail) select s).Count();
if (qbo < 1)
{
return(false);
}
else
{
return(true);
}
}
public IHttpActionResult Put(int id, Employed employed)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (employed.Id != id)
{
return(BadRequest());
}
try
{
_repository.Update(employed);
}
catch
{
return(Conflict());
}
return(Ok(employed));
}
public ActionResult Verify(Employed employed)
{
try
{
using (var db = new ElectronicMedicalRecord_DbContext())
{
var query = (from tbl_employed in db.Employeds
where employed.Username == tbl_employed.Username && employed.Password == tbl_employed.Password
select new
{
tbl_employed.Username,
tbl_employed.Password
}).ToList();
}
return(View("IndexPage"));
}
catch (Exception)
{
return(View("LogInError"));
}
}
public void Delete(Employed employed)
{
db.Employee.Remove(employed);
db.SaveChanges();
}
public void Create(Employed employed)
{
db.Employee.Add(employed);
db.SaveChanges();
}
static void Main(string[] args)
{
Student student = new Student()
{
Name = "Ivan Ivanov", Passport = "EK75960"
};
Employed employed = new Employed()
{
Name = "Ivan Ivanov", Passport = "EK75960"
};
Retired retired = new Retired()
{
Name = "Petr Petrov", Passport = "TY878203"
};
CitizensCollection citizens = new CitizensCollection();
citizens.Add(student);
citizens.Add(retired);
try
{
Console.WriteLine("Attempt to add a person with the same passport number");
citizens.Add(employed);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
Console.WriteLine(new string('_', 50));
foreach (Citizen citizen in citizens)
{
Console.WriteLine($"{citizen.GetType().Name}. Name: {citizen.Name}. Passport: {citizen.Passport}.");
}
Console.WriteLine(new string('_', 50));
Console.WriteLine("Check if the collection contains requested citizen");
Retired retired1 = new Retired()
{
Name = "Stanislav Petrov", Passport = "HJ869595"
};
(bool, int)result = citizens.Contains(retired1);
Console.WriteLine($"Collection contains the requested citizen: {result.Item1}");
result = citizens.Contains(retired);
Console.WriteLine($"Collection contains the requested citizen: {result.Item1}. Number in the collection: {result.Item2}");
Console.WriteLine(new string('_', 50));
Console.WriteLine($"Last citizen is {citizens.ReturnLast().Item1.Name} with the passport number {citizens.ReturnLast().Item1.Passport} and its number in collection is {citizens.ReturnLast().Item2}");
Console.WriteLine(new string('_', 50));
Console.WriteLine("Remove the data about citizen");
citizens.Remove(student);
citizens.Remove(retired1);
foreach (Citizen citizen in citizens)
{
Console.WriteLine($"{citizen.GetType().Name}. Name: {citizen.Name}. Passport: {citizen.Passport}.");
}
Console.ReadKey();
}
public ActionResult <Object> Get(int id)
{
var employes = new Employed().getEmployed(id);
return(employes);
}
static void Main(string[] args)
{
Employed employee = new Employed();
employee.Add(string "Per", int "25000");
}
private static void Main()
{
const string urlSharePointOnpremise = "urlsiteSharePoint";
const string listName = "Employed";
using (var site = new SPSite(urlSharePointOnpremise))
{
var web = site.OpenWeb();
var list = web.Lists.TryGetList(listName);
if (list == null)
{
var createList = web.CreateList(listName, "List of Employed of my Company", TypeList.GenericList, false,
typeof(Employed));
Console.WriteLine(string.Concat("List Employed Created", createList));
}
var employed = new Employed
{
Country = "Spain",
DateBorn = new DateTime(1981, 5, 10),
Job = "Sofware Architect",
LastName = "Diaz Cervera",
Name = "Adrian"
};
var employed2 = new Employed
{
Country = "Spain",
DateBorn = new DateTime(1979, 5, 10),
Job = "Head of Innovation",
LastName = "Diaz Martin",
Name = "Alberto"
};
var logger = new LogManager().GetLogger(new System.Diagnostics.StackTrace().GetFrame(0));;
var repository = new SharePointRepository <Employed>(web, logger, listName, 10);
var resultInsert = repository.Insert(employed);
Console.WriteLine(string.Concat("Insertado el elemento: ", resultInsert));
resultInsert = repository.Insert(employed2);
Console.WriteLine(string.Concat("Insertado el elemento: ", resultInsert));
var employed3 = repository.Get(resultInsert);
Console.WriteLine(string.Concat("Return employed: ", employed3.Name));
var employedCollection = repository.GetAll();
Console.WriteLine(string.Concat("Count Employed: ", employedCollection.Count));
var resultBool = repository.Delete(resultInsert);
Console.WriteLine(string.Concat("Elemento Eliminado ", resultBool));
employedCollection = repository.GetAll();
Console.WriteLine(string.Concat("Count Employed: ", employedCollection.Count));
var queryCaml = @"<Where>
<Eq>
<FieldRef Name='Name' />
<Value Type='Text'>Adrian</Value>
</Eq>
</Where>";
var queryCollection = repository.Query(queryCaml, 1);
Console.WriteLine(string.Concat("Count Employed: ", queryCollection.Count));
var query = new Query().Where().Field("Name", string.Empty).Operator(TypeOperators.Eq).Value("Text", "Adrian");
queryCollection = repository.Query(query, 1);
Console.WriteLine(string.Concat("Count Employed: ", queryCollection.Count));
var firstEmployed = queryCollection.FirstOrDefault();
firstEmployed.Name = "Alberto Javier";
var updateOperation = repository.Save(Convert.ToInt32(firstEmployed.ID), firstEmployed);
Console.WriteLine(string.Concat("Update Employed: ", updateOperation));
Console.ReadLine();
}
}
