public HttpResponseMessage getAccountsOfUser(string loginId)
{
userDetail customer = dbContext.userDetails.Where(x => x.emailId == loginId).Single <userDetail>();
List <accountDetail> accounts = dbContext.accountDetails.Where(y => y.userId == customer.userId).ToList();
List <accountDetailViewModel> acc3 = new List <accountDetailViewModel>();
int i = 0;
foreach (accountDetail xyz in accounts)
{
accountDetailViewModel acc2 = new accountDetailViewModel();
acc2.accountBalance = xyz.accountBalance;
acc2.accountNumber = xyz.accountNumber;
acc2.accountStatus = xyz.accountStatus;
acc2.accountType = xyz.accountType;
acc2.closingDate = xyz.closingDate;
acc2.createdBy = xyz.createdBy;
acc2.createdDate = xyz.createdDate;
acc2.editedDate = xyz.editedDate;
acc2.type = xyz.type;
acc2.updatedBy = xyz.updatedBy;
acc2.userId = xyz.userId;
acc3.Add(acc2);
}
return(Request.CreateResponse(HttpStatusCode.OK, accounts));
}
public HttpResponseMessage getAccountsOfUser(string loginId)
{
userDetail customer = dbContext.userDetails.Where(x => x.emailId == loginId).Single <userDetail>();
List <accountDetail> accounts = dbContext.accountDetails.Where(y => y.userId == customer.userId).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, accounts));
}
private void getUserDetail(string userDetailJson)
{
userDetail userDetail = new userDetail();
MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(userDetailJson));
DataContractJsonSerializer ser = new DataContractJsonSerializer(userDetail.GetType());
userDetail = ser.ReadObject(ms) as userDetail;
ms.Close();
ms.Dispose();
Dispatcher.BeginInvoke(() =>
{
uerImg.Source = new BitmapImage(new Uri(userDetail.user.avatar));
userCompanyName.Text = userDetail.user.company;
userName.Text = userDetail.user.name;
userJob.Text = userDetail.user.department + " - " + userDetail.user.job;
userEmail.Text = userDetail.user.email;
userGrade.Text = userDetail.user.grade;
userMark.Text = userDetail.user.mark;
uerAddress.Text = userDetail.user.city;
userJoin.Text = userDetail.user.create_time;
userPhone.Text = userDetail.user.mobile_phone;
userBox.Visibility = Visibility.Visible;
loading.Visibility = Visibility.Collapsed;
});
}
// Login Request
public IEnumerator CallRegister(string Namme, string Emaill, string Passwoord)
{
// Create a form
WWWForm form = new WWWForm();
form.AddField("name", Namme);
form.AddField("email", Emaill);
form.AddField("password", Passwoord);
UnityWebRequest www = UnityWebRequest.Post("//website", form);
//here we will back our Response.
yield return(www.Send());
if (www.error != null)
{
Debug.Log("ErrorConnection : " + www.error);
loadingText.text = "No Internet";
}
else
{
Debug.Log("Response is " + www.downloadHandler.text);
userDetail userdetail = JsonUtility.FromJson <userDetail> (www.downloadHandler.text);
if (userdetail.response == 1)
{
Debug.Log("" + userdetail.message);
}
}
}
public ActionResult DeleteConfirmed(Guid id)
{
userDetail userDetail = db.UserDetails.Find(id);
db.UserDetails.Remove(userDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,email,firstName,lastName,phone,Office,Position,employeeSince,photo")] userDetail userDetail)
{
if (ModelState.IsValid)
{
db.Entry(userDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userDetail));
}
public ActionResult Edit([Bind(Include = "userID,firstName,lastName,email,phone,positionTitle")] userDetail userDetail)
{
if (ModelState.IsValid)
{
db.Entry(userDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userDetail));
}
public ActionResult Edit([Bind(Include = "userdetailID,Name,Email,ContactNo,userID,ContactNo2")] userDetail userDetail)
{
if (ModelState.IsValid)
{
db.Entry(userDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.userID = new SelectList(db.users, "userID", "username", userDetail.userID);
return(View(userDetail));
}
// GET: userDetails/Delete/5
public ActionResult Delete(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
userDetail userDetail = db.UserDetails.Find(id);
if (userDetail == null)
{
return(HttpNotFound());
}
return(View(userDetail));
}
public ActionResult Create([Bind(Include = "ID,email,firstName,lastName,phone,Office,Position,employeeSince,photo")] userDetail userDetail)
{
if (ModelState.IsValid)
{
Guid memberID;
Guid.TryParse(User.Identity.GetUserId(), out memberID);
userDetail.ID = memberID;
db.UserDetails.Add(userDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userDetail));
}
// GET: userDetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
userDetail userDetail = db.userDetails.Find(id);
if (userDetail == null)
{
return(HttpNotFound());
}
ViewBag.userID = new SelectList(db.users, "userID", "username", userDetail.userID);
return(View(userDetail));
}
public HttpResponseMessage getAllAccountsOfBranchCustomer(int userId, string loginId)
{
userDetail manager = dbContext.userDetails.Where(x => x.emailId == loginId).Single <userDetail>();
List <accountDetail> accounts = new List <accountDetail>();
try
{
userDetail allcustomer = dbContext.userDetails.Single(x => x.userId == userId && x.branchId == manager.branchId);
accounts = (dbContext.accountDetails.Where(x => x.userId == allcustomer.userId)).ToList();
}
catch (Exception exe)
{
return(Request.CreateResponse(HttpStatusCode.NotAcceptable, "This is not your branch customer"));
}
return(Request.CreateResponse(HttpStatusCode.OK, accounts));
}
public IHttpActionResult RegisterUser([FromBody] CustomUserModel userDetails)
{
try
{
var context = new DataModel();
userDetail tempDetails = new userDetail();
tempDetails.Age = userDetails.age;
tempDetails.Fname = userDetails.firstName;
tempDetails.Lname = userDetails.lastName;
context.userDetails.Add(tempDetails);
context.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
throw;
}
}
public void Register(userDetail r_user)
{
try
{ SqlConnection sqlConnection = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlConnection;
cmd.CommandText = "INSERT INTO UserDetail (username,email,password)VALUES(@username,@email,@password) ";
SqlParameter username = new SqlParameter("@username", r_user.Username);
SqlParameter email = new SqlParameter("@email", r_user.email);
SqlParameter password = new SqlParameter("@password", r_user.password);
cmd.Parameters.Add(username);
cmd.Parameters.Add(email);
cmd.Parameters.Add(password);
sqlConnection.Open();
cmd.ExecuteNonQuery();
sqlConnection.Close(); } catch (Exception e)
{
}
}
// Login Request
public IEnumerator CallLogin(string Emaill, string Paswoord)
{
// Create a form
WWWForm form = new WWWForm();
form.AddField("useremail", Emaill);
form.AddField("userpassword", Paswoord);
///
////
UnityWebRequest www = UnityWebRequest.Post("//////website", form);
//here we will back our Response.
yield return(www.Send());
if (www.error != null)
{
Debug.Log("ErrorConnection : " + www.error);
loadingText.text = "";
}
else
{
Debug.Log("Response is " + www.downloadHandler.text);
userDetail userdetail = JsonUtility.FromJson <userDetail> (www.downloadHandler.text);
if (userdetail.response == 1)
{
Debug.Log("Login Success : Name is : " + userdetail.email);
//StartCoroutine(LoadNewScene(1));
}
else
{
Debug.Log("Login Failed : Check Paramters");
loadingText.text = "";
}
}
}
