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);
}
