public RegistrationEntity RegisterUser(RegistrationEntity entity) { entity.Success = true; if (Context.User.FirstOrDefault(d => d.Name.Equals(entity.UserName)) != null) { entity.Success = false; entity.Message = "The user with same name already exists!"; return(entity); } var passwordSalt = Guid.NewGuid().ToString(); byte[] bytes = Encoding.Default.GetBytes(passwordSalt); //转成 Base64 形式的 System.String passwordSalt = Convert.ToBase64String(bytes); var user = new User { Name = entity.UserName, Password = SHA_Encrypt(entity.Password, passwordSalt), PasswordSalt = passwordSalt, FirstName = entity.FirstName, SecondName = entity.SecondName, Mail = entity.Mail, MobileNo = entity.MobileNo, PhoneNo = entity.MobileNo }; Context.User.Add(user); Context.SaveChanges(); entity.Password = user.Password; return(entity); }
/// <summary> /// 从界面获取对象 /// </summary> /// <returns></returns> private RegistrationEntity GetRegistrationUI() { RegistrationViewEntity RegInfo = m_Registration.GetOverall(RegisterNo); bool IsCheckOver = true; if (!String.IsNullOrWhiteSpace(txtReviewDate.Text)) { IsCheckOver = false; } RegistrationEntity Result = new RegistrationEntity { RegisterNo = RegInfo.RegisterNo, RegisterDate = RegInfo.RegisterDate, PersonID = RegInfo.PersonID, PackageID = RegInfo.PackageID, IsCheckOver = IsCheckOver, Conclusion = txtConclusion.Text, Recommend = txtRecommend.Text, OverallDate = DateTime.Now.Date, OverallDoctor = UserName, ReviewDate = EnvConverter.ToDateTime(txtReviewDate.Text), ReviewSummary = txtReviewSummary.Text, EvaluateResult = drpEvaluateResult.SelectedValue, HealthCondition = drpHealthCondition.SelectedValue, }; return(Result); }
public int CreateRegistration(RegistrationEntity registrationEntity) { using (var scope = new TransactionScope()) { var registration = new Registration() { fname = registrationEntity.fname, lname = registrationEntity.lname, gender = registrationEntity.gender, dob = registrationEntity.dob, contactNo = registrationEntity.contactNo, email = registrationEntity.email, address = registrationEntity.address, trainings = registrationEntity.trainings, goals = registrationEntity.goals, timeSlot = registrationEntity.timeSlot, adMedia = registrationEntity.adMedia, imageId = registrationEntity.imageId, repId = registrationEntity.repId, registeredOn = registrationEntity.registeredOn, lastChangedOn = registrationEntity.lastChangedOn, status = registrationEntity.status }; _unitOfWork.RegistrationRepository.Insert(registration); _unitOfWork.Save(); scope.Complete(); return(registration.regId); } }
public bool UpdateRegistration(int registrationId, RegistrationEntity registrationEntity) { var success = false; if (registrationEntity != null) { using (var scope = new TransactionScope()) { var registration = _unitOfWork.RegistrationRepository.GetByID(registrationId); if (registration != null) { registration.fname = registrationEntity.fname; registration.lname = registrationEntity.lname; registration.gender = registrationEntity.gender; registration.dob = registrationEntity.dob; registration.contactNo = registrationEntity.contactNo; registration.email = registrationEntity.email; registration.address = registrationEntity.address; registration.trainings = registrationEntity.trainings; registration.goals = registrationEntity.goals; registration.timeSlot = registrationEntity.timeSlot; registration.adMedia = registrationEntity.adMedia; registration.imageId = registrationEntity.imageId; registration.repId = registrationEntity.repId; registration.registeredOn = registrationEntity.registeredOn; registration.lastChangedOn = registrationEntity.lastChangedOn; registration.status = registrationEntity.status; _unitOfWork.Save(); scope.Complete(); success = true; } } } return(success); }
public async Task <ActionResult> Delete(RegistrationEntity entity) { using (var client = new HttpClient()) { client.BaseAddress = new Uri(Baseurl); client.DefaultRequestHeaders.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage Res = await client.DeleteAsync("api/RegApi/Delete/" + entity.Id); if (Res.IsSuccessStatusCode) { var Response = Res.Content.ReadAsStringAsync().Result; var isdeleted = JsonConvert.DeserializeObject <bool>(Response); if (isdeleted) { return(RedirectToAction("Index")); } } } return(View()); }
public HttpResponseMessage Update(RegistrationEntity _Update) { HttpResponseMessage response; RegistrationEntity userData = new RegistrationEntity(); try { if (_Update == null) { response = Request.CreateResponse(HttpStatusCode.PreconditionFailed, "Update can not be null!"); } else if (string.IsNullOrWhiteSpace(_Update.name)) { response = Request.CreateResponse(HttpStatusCode.PreconditionFailed, "update successfuly"); } else { userData = RegistrationProcCall.usp_user_registrationupdate(_Update); response = Request.CreateResponse(HttpStatusCode.OK, userData); } } catch (Exception) { response = Request.CreateResponse(HttpStatusCode.InternalServerError); } return(response); }
public HttpResponseMessage Add(RegistrationEntity _RegisterAdd) { HttpResponseMessage response; try { if (string.IsNullOrWhiteSpace(_RegisterAdd.name)) { response = Request.CreateResponse(HttpStatusCode.PreconditionFailed, "Name can not be blank!"); } else { //ListingEntityID _ListEntityID = new ListingEntityID(); int new_user_id = RegistrationProcCall.usp_user_registrationAdd(_RegisterAdd); //_ListEntityID.ListID = new_user_id; response = Request.CreateResponse(HttpStatusCode.OK, new_user_id); //return Request.CreateErrorResponse(HttpStatusCode.OK, " Register successfully"); } } catch (Exception ex) { response = Request.CreateResponse(HttpStatusCode.InternalServerError); } return(response); }
public async Task <ActionResult> Edit(int id) { RegistrationEntity regInfo = new RegistrationEntity(); using (var client = new HttpClient()) { client.BaseAddress = new Uri(Baseurl); client.DefaultRequestHeaders.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage Res = await client.GetAsync("api/RegApi/GetByid/" + id); if (Res.IsSuccessStatusCode) { var EmpResponse = Res.Content.ReadAsStringAsync().Result; regInfo = JsonConvert.DeserializeObject <RegistrationEntity>(EmpResponse); } return(View(regInfo)); } return(View()); }
public static RegistrationEntity usp_user_registrationupdate(RegistrationEntity _Update) { RegistrationEntity _UserEntity = new RegistrationEntity(); using (var connection = SQLConnection.GetOpenSQLConnection()) { // string sqlQuery = @"usp_user_registrationupdate @id,@name,@contactnumber,@email,@password,@address,@fathername,@addharnumber,@pannumber,@selectRole"; // _UserEntity = connection.Query<RegistrationEntity>(sqlQuery, new {id = _Update.id, name = _Update.name, contactnumber = _Update.contactnumber, email = _Update.email, password = _Update.password, address = _Update.address, fathername = _Update.fathername, addharnumber = _Update.addharnumber, pannumber = _Update.pannumber, selectRole = _Update.selectRole }).FirstOrDefault(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_user_registrationupdate"; cmd.Parameters.Add("@id", SqlDbType.Int).Value = _Update.id; cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = _Update.name; cmd.Parameters.Add("@contactnumber", SqlDbType.Int).Value = _Update.contactnumber; cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = _Update.email; //cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = _Update.password; cmd.Parameters.Add("@address", SqlDbType.VarChar).Value = _Update.address; cmd.Parameters.Add("@fathername", SqlDbType.VarChar).Value = _Update.fathername; cmd.Parameters.Add("@addharnumber", SqlDbType.Int).Value = _Update.addharnumber; cmd.Parameters.Add("@pannumber", SqlDbType.VarChar).Value = _Update.pannumber; cmd.Parameters.Add("@selectRole", SqlDbType.VarChar).Value = _Update.selectRole; cmd.Connection = connection; _UserEntity = (RegistrationEntity)cmd.ExecuteScalar(); } return(_UserEntity); }
public async Task <IActionResult> Index() { var orchestrations = new OrchestrationEntity().FetchAll(); var sb = new StringBuilder(); foreach (var orchestration in orchestrations) { var cl = clientFactory.CreateClient(); var statusRequest = new HttpRequestMessage(HttpMethod.Get, orchestration.StatusQueryGetUri); var statusResult = await cl.SendAsync(statusRequest); var status = OrchestrationStatus.FromJson(await statusResult.Content.ReadAsStringAsync()); var reg = new RegistrationEntity().Fetch(status.name, status.instanceId); sb.Append($"<tr>"); sb.Append($"<td>{reg?.UserName ?? "unknown"}</td>"); sb.Append($"<td>{reg?.UserEmail ?? "unknown"}</td>"); sb.Append($"<td>{HasVerified(reg?.EmailLastVerified ?? TableEntityBase.MinDate, "EmailVerified", orchestration)}</td>"); sb.Append($"<td>{reg?.UserPhone ?? "unknown"}</td>"); sb.Append($"<td>{HasVerified(reg?.PhoneLastVerified ?? TableEntityBase.MinDate, "SmsVerified", orchestration)}</td>"); sb.Append($"<td>{status.customStatus}</td>"); sb.Append($"<td>{status.runtimeStatus}</td>"); sb.Append($"</tr>"); } ViewBag.rows = sb.ToString(); return(View("Index")); }
/// <summary> /// Creates a new registraton. /// </summary> /// <param name="contact">The contact method, e.g. <c>mailto:[email protected]</c>.</param> /// <returns>The ACME account created.</returns> public async Task <AcmeAccount> NewRegistraton(params string[] contact) { if (this.key == null) { this.key = new AccountKey(); } var registration = new RegistrationEntity { Contact = contact, Resource = ResourceTypes.NewRegistration }; var uri = await this.handler.GetResourceUri(registration.Resource); var result = await this.handler.Post(uri, registration, key); ThrowIfError(result); var account = new AcmeAccount { Links = result.Links, Data = result.Data, Json = result.Json, Raw = result.Raw, Location = result.Location, Key = key.Export(), ContentType = result.ContentType }; return(account); }
public bool InsertRegistration(RegistrationEntity re) { try { Registration rdb = new Registration();//contain the new of data to be inserted rdb.Name = re.Name; rdb.Address = re.Address; rdb.DOB = re.DOB; rdb.DOJ = re.DOJ; rdb.Nationality = re.Nationality; rdb.Qualification = re.Quali; rdb.Hobbies = re.Hobbies; rdb.SkillSets = re.Skills; rdb.Salary = re.Salary; db.Registrations.AddObject(rdb); //add to conceptual model int res = db.SaveChanges(); //update the values in conceptual model to actual DB if (res > 0) { return(true); } } catch (Exception ex) { throw ex; } return(false); }
public async Task <RegistrationEntity> UpdateRegistrationByIdAsync(RegistrationEntity registrationEntity, CancellationToken token) { _dbContext.Registrations.Update(registrationEntity); await _dbContext.SaveChangesAsync(token); return(registrationEntity); }
public RegistrationEntity SelectByID(int id) { RegistrationEntity entity = new RegistrationEntity(); try { var data = db.Registrations.Where(x => x.RegID == id).SingleOrDefault(); entity.Name = data.Name; entity.Address = data.Address; entity.DOB = data.DOB; entity.DOJ = data.DOJ; entity.Gender = data.Gender; entity.Nationality = data.Nationality; entity.Quali = data.Qualification; entity.Skills = data.SkillSets; entity.Hobbies = data.Hobbies; entity.Salary = data.Salary; } catch (Exception ex) { throw ex; } return(entity); }
// PUT: api/Registration/5 public bool Put(int id, [FromBody] RegistrationEntity RegistrationEntity) { if (id > 0) { return(_RegistrationServices.UpdateRegistration(id, RegistrationEntity)); } return(false); }
public async Task <RegistrationEntity> CreateRegistrationAsync(RegistrationEntity registrationEntity, CancellationToken token) { await _dbContext.Registrations.AddAsync(registrationEntity, token); await _dbContext.SaveChangesAsync(token); return(await _dbContext.Registrations .Include(x => x.Gender) .SingleAsync(registration => registration.Id == registrationEntity.Id, token)); }
public static RegistrationEntity usp_user_registrationlogin(LoginModel _RegisterLogin) { RegistrationEntity _UserEntity = new RegistrationEntity(); using (var connection = SQLConnection.GetOpenSQLConnection()) { string sqlQuery = "usp_user_registrationlogin @email,@Password"; _UserEntity = connection.Query <RegistrationEntity>(sqlQuery, new { email = _RegisterLogin.email, Password = _RegisterLogin.Password }).FirstOrDefault(); } return(_UserEntity); }
public bool Insert(RegistrationEntity entity) { try { return(obj.Insert(entity)); } catch (Exception ex) { throw; } }
public bool Update(RegistrationEntity entity) { try { return(obj.Update(entity)); } catch (Exception ex) { throw; } }
public static RegistrationEntity usp_user_registrationget(RegistrationEntity _UserId) { RegistrationEntity _UserEntity = new RegistrationEntity(); using (var connection = SQLConnection.GetOpenSQLConnection()) { string sqlQuery = "usp_user_registrationget @id"; _UserEntity = connection.Query <RegistrationEntity>(sqlQuery, new { id = _UserId.id }).FirstOrDefault(); } return(_UserEntity); }
protected void btnSave_Click(object sender, EventArgs e) { RegistrationEntity Result = GetRegistrationUI(); m_Registration.SaveOverallChecked(Result); ShowMessage("总检数据保存成功!"); //int Succeed = m_Registration.SaveRegistration(Result); //if (Succeed > 0) ShowMessage("数据保存成功!"); //if (Succeed < 0) ShowMessage("数据保存失败!"); DataBind(); SetUIState("Default"); }
public object Update(RegistrationEntity entity) { var isupdated = service.Update(entity); if (isupdated) { return(true); } else { return(false); } }
public object Insert(RegistrationEntity entity) { var isinserted = service.Insert(entity); if (isinserted) { var json = true; return(json); } else { return(false); } }
/// <summary> /// Adds the user registration data to the table. /// </summary> /// <param name="registration">The registration.</param> public async void Register(Registration registration) { try { var table = this.cloudTableClient.GetTableReference(Constants.TableName); await table.CreateIfNotExistsAsync(); var registrationEntity = RegistrationEntity.FromModel(registration); TableOperation addRegistrationOperation = TableOperation.InsertOrReplace(registrationEntity); await table.ExecuteAsync(addRegistrationOperation); } catch (Exception) { throw; } }
public static int usp_user_registrationAdd(RegistrationEntity _RegisterAdd) { int userid = 0; using (var connection = SQLConnection.GetOpenSQLConnection()) { //string sqlQuery = "usp_user_registrationAdd @name,@contactnumber,@email,@password,@address,@fathername,@addharnumber,@pannumber,@selectRole"; //userid = connection.Query<int>(sqlQuery, new //{ // name = _RegisterAdd.name, // contactnumber = _RegisterAdd.contactnumber, // email = _RegisterAdd.email, // password = _RegisterAdd.password, // address = _RegisterAdd.address, // fathername = _RegisterAdd.fathername, // addharnumber = _RegisterAdd.addharnumber, // pannumber = _RegisterAdd.pannumber, // selectRole = _RegisterAdd.selectRole //}).FirstOrDefault(); // // SqlConnection con = new SqlConnection(strConnString); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_user_registrationAdd"; // cmd.Parameters.Add("@id", SqlDbType.Int).Value = _RegisterAdd.id; cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = _RegisterAdd.name; cmd.Parameters.Add("@contactnumber", SqlDbType.Int).Value = _RegisterAdd.contactnumber; cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = _RegisterAdd.email; cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = _RegisterAdd.password; cmd.Parameters.Add("@address", SqlDbType.VarChar).Value = _RegisterAdd.address; cmd.Parameters.Add("@fathername", SqlDbType.VarChar).Value = _RegisterAdd.fathername; cmd.Parameters.Add("@addharnumber", SqlDbType.Int).Value = _RegisterAdd.addharnumber; cmd.Parameters.Add("@pannumber", SqlDbType.VarChar).Value = _RegisterAdd.pannumber; cmd.Parameters.Add("@selectRole", SqlDbType.VarChar).Value = _RegisterAdd.selectRole; cmd.Connection = connection; userid = (int)cmd.ExecuteScalar(); } return(userid); }
public RegistrationEntity GetbyId(int id) { RegistrationEntity entity = new RegistrationEntity(); using (var db = new DemoDBEntities()) { var record = db.RegistartionMasters.Find(id); if (record != null) { entity.Id = record.Id; entity.FullName = record.FullName; entity.Gender = record.Gender; entity.Emailid = record.Emailid; entity.Address = record.Address; entity.Mobno = record.Mobno; } } return(entity); }
public bool InsertRegistration(RegistrationEntity entity) { if (entity.DOB >= DateTime.Now) { throw new Exception("DOB invalid"); } if (entity.DOJ >= DateTime.Now) { throw new Exception("Cannot register an employee who has not joined"); } if (entity.Salary >= 10000 && entity.Salary <= 75000) { } else { throw new Exception("Salary range between 10000 and 75000 "); } return(dal.InsertRegistration(entity)); }
public bool Update(RegistrationEntity entity) { bool isupated = false; using (var db = new DemoDBEntities()) { RegistartionMaster record = db.RegistartionMasters.Find(entity.Id); record.Address = entity.Address; record.Emailid = entity.Emailid; record.FullName = entity.FullName; record.Gender = entity.Gender; record.IsActive = true; record.Mobno = entity.Mobno; db.SaveChanges(); isupated = true; } return(isupated); }
public async Task <ActionResult> Create(RegistrationEntity entity) { using (var client = new HttpClient()) { client.BaseAddress = new Uri(Baseurl); client.DefaultRequestHeaders.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response = await client.PostAsJsonAsync("api/RegApi/Insert", entity); if (response.IsSuccessStatusCode) { var result = response.Content.ReadAsStringAsync().Result; return(RedirectToAction("Index")); } return(View()); } }
// get data public HttpResponseMessage UserDetail(RegistrationEntity _UserId) { HttpResponseMessage response; RegistrationEntity userData = new RegistrationEntity(); try { //check for null paramter if (_UserId == null) { throw new Exception("Input parameter not provided"); } else if (_UserId.id == 0) //check for zero in user id { //response = Request.CreateResponse(HttpStatusCode.PreconditionFailed, "UserID can not be zero!"); throw new Exception("User ID can not be zero"); } else { //get data from database userData = RegistrationProcCall.usp_user_registrationget(_UserId); if (userData == null) { //throw exception in not record found throw new Exception("User Information could not be found"); } else { //return user data response = Request.CreateResponse(HttpStatusCode.OK, userData); } } } catch { response = Request.CreateResponse(HttpStatusCode.InternalServerError, "Server error occured while processing request"); } return(response); }