public void AddnewTeamMember(CareTeamMemberView member) { List <SqlParameter> list = new List <SqlParameter>(); list.Add(GetNullableStringParameter("@LastName", member.LastName)); list.Add(GetNullableStringParameter("@FirstName", member.FirstName)); list.Add(GetNullableStringParameter("@MiddleName", member.MiddleName)); list.Add(GetNullableStringParameter("@Gender", member.Gender)); list.Add(GetNullableStringParameter("@Profession", member.ProfessionalCategoryId)); list.Add(GetNullableStringParameter("@Phone", member.PhoneNumber)); list.Add(GetNullableStringParameter("@Cell", member.CellNumber)); list.Add(GetNullableStringParameter("@Email", member.EmailAddress)); list.Add(GetNullableDateTimeParameter("@dateofBirth", member.DateofBirth)); list.Add(GetNullableStringParameter("@Company", "compaTest")); list.Add(GetNullableStringParameter("@Demographic", member.Demographic)); list.Add(GetNullableStringParameter("@EmergencyContact", member.EmergencyContactName)); list.Add(GetNullableStringParameter("@EmergencyPhone", member.EmergencyContactPhoneNumber)); list.Add(GetNullableDateTimeParameter("@HireDate", member.HireDate)); list.Add(GetNullableStringParameter("@TerminationDate", DateTime.Now)); list.Add(GetNullableStringParameter("@Specialization", member.Specialization)); list.Add(GetNullableStringParameter("@Address1", member.Address1)); list.Add(GetNullableStringParameter("@Address2", member.Address2)); list.Add(GetNullableStringParameter("@City", member.City)); list.Add(GetNullableStringParameter("@Province", member.Province)); list.Add(GetNullableStringParameter("@PostalCode", member.PostalCode)); list.Add(GetNullableStringParameter("@Country", member.CountryId)); list.Add(GetNullableStringParameter("@PhotoFilePath", member.PhotoFilePath)); _careteamMemberrepository.InsertWithStoredProcedure("[Usp_AddnewTeamMember] @LastName, @FirstName, @MiddleName,@Gender, @Profession, @Phone, @Cell,@Email, @dateofBirth, @Company,@Demographic, @EmergencyContact," + "@EmergencyPhone, @HireDate, @TerminationDate, @Specialization, @Address1,@Address2, @City,@Province, @PostalCode, @Country ,@Photofilepath", list.ToArray()); }
public async Task <IActionResult> Register(TeamMemberViewModel model, IFormFile PhotoFilePath) { if (ModelState.IsValid) { try { CareTeamMemberView mod = null; List <TeamMemberViewModel> list = new List <TeamMemberViewModel>(); if (PhotoFilePath == null || PhotoFilePath.Length == 0) { return(Content("file not selected")); } if (PhotoFilePath.Length > 0) { var path = Path.Combine( Directory.GetCurrentDirectory(), "wwwroot/uploads/", PhotoFilePath.FileName); using (var stream = new FileStream(path, FileMode.Create)) { await PhotoFilePath.CopyToAsync(stream); } mod = new CareTeamMemberView() { Address1 = model.Address, CellNumber = model.CellNumber, City = model.City, Company = model.Company, DateofBirth = model.DateofBirth, Demographic = model.Demographic, EmailAddress = model.EmailAddress, EmergencyContactName = model.EmergencyContactName, EmergencyContactPhoneNumber = model.EmergencyContactPhoneNumber, FirstName = model.FirstName, Gender = model.Gender, HireDate = model.HireDate, LastName = model.LastName, MiddleName = model.MiddleName, PhoneNumber = model.PhoneNumber, PostalCode = model.PostalCode, ProfessionalCategoryId = Convert.ToUInt32(model.profession), Specialization = model.Specialization, Province = model.Province, TerminationDate = model.TerminationDate, PhotoFilePath = PhotoFilePath.FileName, Address2 = "", CountryId = Convert.ToUInt32(model.Country), PlaceofBirth = model.PlaceofBirth }; } _teamMemberService.AddnewTeamMember(mod); list.Add(model); return(View("Index", list)); } catch (Exception) { throw; } } return(View("NewTeamMember", model)); }