public async Task<IHttpActionResult> AddInstution(Institution foo) { //var contentType = Request.Content.Headers.ContentType.MediaType; //var pp = System.Web.HttpContext.Current.Request["RegisterBindingModel"]; // Bank foo = Newtonsoft.Json.JsonConvert.DeserializeObject<Bank>(pp) as Bank; // JsonSerializer serializer = JsonSerializer.Create(Configuration.Formatters.JsonFormatter.SerializerSettings); // var requestParams = Request.Content.ReadAsStringAsync().Result; var httpRequest = HttpContext.Current.Request; try { var _db = new ApplicationDbContext(); string currentUserId = User.Identity.GetUserId(); Institution aaa = new Institution(); aaa.Institution_Code = foo.Institution_Code; aaa.Institution_Name = foo.Institution_Name; aaa.InstitutionType_Code = foo.InstitutionType_Code; _db.Institutions.Add(aaa); var kk = _db.SaveChanges(); // _db.SaveChanges(); return Ok(); } catch (Exception ee) { return BadRequest(); ; } }
public List<Institution> GetClient() { var _db = new ApplicationDbContext(); var vv = (from c in _db.Institution_Type join o in _db.Institutions on new { a = c.InstitutionType_Code } equals new { a = o.InstitutionType_Code } // where ((o.parent_id == User.Identity.Name)) // where ((c.DateCreated.Date == start_date) && (c.DateCreated.Date <= end_date)) // where (c.DateCreated.Date >= start_date.Date && c.DateCreated.Date <= end_date.Date) select new { c.InstitutionType_Name, o.Institution_Code, o.Institution_Name }).ToList(); List<Institution> kk = new List<Institution>(); foreach (var dd in vv) { Institution xx = new Institution(); xx.Institution_Code = dd.Institution_Code; xx.Institution_Name = dd.Institution_Name; xx.InstitutionType_Code = dd.InstitutionType_Name; kk.Add(xx); } // List<Clients> currentUser = _db.Clients.ToList(); return kk; }
public async Task<IHttpActionResult> AddClients(Institution foo2) { var httpRequest = HttpContext.Current.Request; //var pp = System.Web.HttpContext.Current.Request["CreateRoleBindingModel"]; //Clients foo = Newtonsoft.Json.JsonConvert.DeserializeObject<Clients>(pp) as Clients; //if (httpRequest.Files.Count > 0) //{ // foreach (string file in httpRequest.Files) // { // var files = new List<string>(); // if (file == "FileUpload") // { // var postedFile = httpRequest.Files[file]; // var vfile = postedFile.FileName.Replace("\"", string.Empty).Replace("'", string.Empty); // vfile = Stp(vfile); // string FileName = HttpContext.Current.Server.MapPath("~/Img/" + vfile); // // dd.cac_file = "/images/" + vfile; // foo.Image_url = "Img/" + vfile; // postedFile.SaveAs(FileName); // } // } //} var _db = new ApplicationDbContext(); _db.Institutions.Add(foo2); _db.SaveChanges(); return Ok(); }
public List<Institution> GetInstitution2([FromUri] String property1) { var _db = new ApplicationDbContext(); var vv = (from c in _db.Institution_Type join o in _db.Institutions on new { a = c.InstitutionType_Code } equals new { a = o.InstitutionType_Code } where c.InstitutionType_Code == property1 select new { c.InstitutionType_Name, o.Institution_Code, o.Institution_Name }).ToList(); List<Institution> kk = new List<Institution>(); foreach (var dd in vv) { Institution xx = new Institution(); xx.Institution_Code = dd.Institution_Code; xx.Institution_Name = dd.Institution_Name; xx.InstitutionType_Code = dd.InstitutionType_Name; kk.Add(xx); } // List<Institution_Type> currentUser = _db.Institution_Type.ToList(); return kk; }