public async Task <IHttpActionResult> PutUser_Data(int id, User_Data user_Data)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != user_Data.Id)
{
return(BadRequest());
}
db.Entry(user_Data).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!User_DataExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
[Test] // #20
public void t()
{ //@ check delete user
User_Data ud = new User_Data();
Backend.User u = new Backend.User("a", "a", "112233");
ud.Remove(u);
Assert.IsTrue(!ud.Contains(u));
}
[Test] // #18
public void r()
{ //@ check user creation
User_Data ud = new User_Data();
Backend.User u = new Backend.User("a", "a", "112233");
ud.Add(u);
Assert.IsTrue(ud.Contains(u));
}
public void UpdateUser(User_Data data)
{
#region SQL
const string SQL = @"
MERGE [Users] AS T
USING (SELECT @us_id, @us_iso_id, @us_first_name, @us_last_name, @us_login, @us_password, @us_email,
@us_gp_id, @us_active, @us_salt, @us_br_id) AS
S ([us_id], [us_iso_id], [us_first_name], [us_last_name], [us_login], [us_password], [us_email],
[us_gp_id], [us_active], [us_salt], [us_br_id])
ON (T.us_id = S.us_id)
WHEN NOT MATCHED BY TARGET
THEN
INSERT([us_iso_id], [us_first_name], [us_last_name], [us_login], [us_password], [us_email],
[us_gp_id], [us_active], [us_salt], [us_br_id])
VALUES(S.us_iso_id, S.us_first_name, S.us_last_name, S.us_login, S.us_password, S.us_email,
S.us_gp_id, S.us_active, S.us_salt, S.us_br_id)
WHEN MATCHED
THEN UPDATE SET
us_iso_id = S.us_iso_id,
us_first_name = S.us_first_name,
us_last_name = S.us_last_name,
us_login = S.us_login,
us_password = S.us_password,
us_email = S.us_email,
us_gp_id = S.us_gp_id,
us_active = S.us_active,
us_salt = S.us_salt,
us_br_id= S.us_br_id
--WHEN NOT MATCHED BY SOURCE
-- THEN DELETE
OUTPUT $action, inserted.*, deleted.*;";
#endregion
using (var conn = new SqlConnection(ImagesConnectionString))
{
conn.Open();
using (var comm = new SqlCommand(SQL, conn))
{
comm.Parameters.AddWithValue("@us_id", data.us_id);
comm.Parameters.AddWithValue("@us_iso_id", data.us_iso_id);
comm.Parameters.AddWithValue("@us_first_name", data.us_first_name);
comm.Parameters.AddWithValue("@us_last_name", data.us_last_name);
comm.Parameters.AddWithValue("@us_login", data.us_login);
comm.Parameters.AddWithValue("@us_password", data.us_password);
comm.Parameters.AddWithValue("@us_email", data.us_email);
comm.Parameters.AddWithValue("@us_gp_id", data.us_gp_id);
comm.Parameters.AddWithValue("@us_active", data.us_active);
comm.Parameters.AddWithValue("@us_salt", data.us_salt);
comm.Parameters.AddWithValue("@us_br_id", data.us_br_id);
comm.ExecuteNonQuery();
}
}
}
public void LoadUserData(User_Data ud)
{
User.Height = ud.Height;
String unit = ud.Unit;
if (unit.Equals("me"))
{
unit = "metrical";
}
Preference.MeasurementSystem = MeasurementSystem.GetMeasurementSystem(unit);
}
public async Task <IHttpActionResult> GetUser_Data(int id)
{
User_Data user_Data = await db.User_Data.FindAsync(id);
if (user_Data == null)
{
return(NotFound());
}
return(Ok(user_Data));
}
public async Task <IHttpActionResult> PostUser_Data(User_Data user_Data)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.User_Data.Add(user_Data);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = user_Data.Id }, user_Data));
}
public async Task <IHttpActionResult> DeleteUser_Data(int id)
{
User_Data user_Data = await db.User_Data.FindAsync(id);
if (user_Data == null)
{
return(NotFound());
}
db.User_Data.Remove(user_Data);
await db.SaveChangesAsync();
return(Ok(user_Data));
}
private async void LoginButton_Clicked(object sender, EventArgs e)
{
//Cont_Work_DSoap, Cont_Work_DSoap12 두개중에 어느거?..
Cont_Work_DSoapClient client = new Cont_Work_DSoapClient(EndpointConfiguration.Cont_Work_DSoap12);
await client.OpenAsync();
User_Data[] ud = new User_Data[1];
ud[0].Tran_Code = "111";
ud[0].Tran_Name = "111";
ud[0].Work_Group = "111";
await client.Log_inAsync("userid", "pass", ud);
await client.CloseAsync();
}
public void CreateUser()
{
User_Data user_Data = new User_Data();
var res = user_Data.CreateUser(new ModelsClass.MethodParameters.CreateUser()
{
Email = "*****@*****.**",
IdNumber = 1321654,
IdType = 2,
Name = "Prueba_1",
PassWord = "******",
Surname = "Apellido1"
});
Assert.Pass();
}
public Main()
{
InitializeComponent();
EmartDataContext emartDataContext = new EmartDataContext();
//data classes of the enities
List <DAL.User> userSqlDB = (from s in emartDataContext.Users select s).ToList();
List <Backend.User> userDB = Change.UserDalToBackendList(userSqlDB);
User_Data user_data = new User_Data(userDB);
List <DAL.Customer> clubMemberSqlDB = (from s in emartDataContext.Customers select s).ToList();
List <Club_Member> clubMemberDB = Change.CustomerDalToBackendList(clubMemberSqlDB);
ClubMember_Data clubMember_data = new ClubMember_Data(clubMemberDB);
List <DAL.Department> departmentSqlDB = (from s in emartDataContext.Departments select s).ToList();
List <Backend.Department> departmentDB = Change.DepartmentDalToBackendList(departmentSqlDB);
Department_Data department_data = new Department_Data(departmentDB);
List <DAL.Employee> EmployeeSqlDB = (from s in emartDataContext.Employees select s).ToList();
List <Backend.Employee> EmployeeDB = Change.EmployeeDalToBackendList(EmployeeSqlDB);
Employee_Data employee_data = new Employee_Data(EmployeeDB);
List <DAL.Product> productSqlDB = (from s in emartDataContext.Products select s).ToList();
List <Backend.Product> productDB = Change.ProductDalToBackendList(productSqlDB);
Product_Data product_data = new Product_Data(productDB);
List <DAL.Transaction> transactionSqlDB = (from s in emartDataContext.Transactions select s).ToList();
List <Backend.Transaction> transactionDB = Change.TransactionDalToBackendList(transactionSqlDB);
List <DAL.Recipt> reciptSqlDB = (from s in emartDataContext.Recipts select s).ToList();
List <Backend.Receipt> reciptDB = Change.ReciptDalToBackendList(reciptSqlDB);
Transaction_Data transaction_data = new Transaction_Data(transactionDB, reciptDB);
Location_Data location_data = new Location_Data();
// managers
DAL_Manager dal_manager = new DAL_Manager(user_data, clubMember_data, department_data, employee_data, product_data, transaction_data, location_data);
BL_Manager BL_manager = new BL_Manager(dal_manager);
Window mw = new MainWindow(BL_manager);
mw.Show();
this.Close();
}
//[ProducesResponseType(typeof(CreateUser))]
public ActionResult LoginUser(UserLoginIn input)
{
if (ModelState.IsValid)
{
User_Data user_Business = new User_Data();
var output = user_Business.Login(input);
switch (output.Result)
{
case (Result.error):
return(StatusCode(500, output));
default:
return(Ok(output));
}
}
else
{
return(BadRequest());
}
}
private void UploadStringCompleted(object sender, UploadStringCompletedEventArgs e)
{
if (e.Error != null)
{
return;
}
else
{
String response = e.Result;
Error err = CheckForError(response);
RequestType rt = (RequestType)e.UserState;
if (rt.Equals(RequestType.LOGIN))
{
if (!err.Response.Equals("SUCCESS"))
{
App.MealViewModel.Status.ErrorOccured();
}
else
{
Login login = JsonConvert.DeserializeObject <Login>(response);
userId = login.UserId;
authKey = login.Auth;
App.MealViewModel.Status.LoggedIn();
resendQueuedRequests();
}
}
else if (rt.Equals(RequestType.REGISTER))
{
if (!err.Response.Equals("SUCCESS"))
{
App.MealViewModel.Status.ErrorOccured();
App.MealViewModel.RegistrationFailedTxt = "Registration failed! " + err.Msg;
}
else
{
App.MealViewModel.RegistrationFailedTxt = "Registration done!";
}
}
else if (rt.Equals(RequestType.USER_DATA))
{
if (!err.Response.Equals("SUCCESS"))
{
App.MealViewModel.Status.ErrorOccured();
}
else
{
User_Data ud = JsonConvert.DeserializeObject <User_Data>(response);
App.MealViewModel.LoadUserData(ud);
}
}
else if (rt.Equals(RequestType.LIST_NUTRITION))
{
if (!err.Response.Equals("SUCCESS"))
{
App.MealViewModel.Status.ErrorOccured();
}
else
{
List_Nutrition ln = JsonConvert.DeserializeObject <List_Nutrition>(response);
mainLogic.Fis = ln.Items;
}
}
else if (rt.Equals(RequestType.LIST_FITNESS))
{
if (!err.Response.Equals("SUCCESS"))
{
App.MealViewModel.Status.ErrorOccured();
}
else
{
List_Fitness lf = JsonConvert.DeserializeObject <List_Fitness>(response);
mainLogic.Exercises = lf.Items;
}
}
else if (rt.Equals(RequestType.TRACK_DIET))
{
if (!err.Response.Equals("SUCCESS"))
{
App.MealViewModel.Status.ErrorOccured();
App.MealViewModel.CreateMealHistory(null);
}
else
{
Track_Diet td = JsonConvert.DeserializeObject <Track_Diet>(response);
App.MealViewModel.CreateMealHistory(td.Items);
}
}
else if (rt.Equals(RequestType.TRACK_FITNESS))
{
if (!err.Response.Equals("SUCCESS"))
{
App.MealViewModel.Status.ErrorOccured();
App.MealViewModel.CreateFitnessHistory(null);
}
else
{
Track_Fitness tf = JsonConvert.DeserializeObject <Track_Fitness>(response);
App.MealViewModel.CreateFitnessHistory(tf.Items);
}
}
else if (rt.Equals(RequestType.TRACK_WEIGHT))
{
if (!err.Response.Equals("SUCCESS"))
{
App.MealViewModel.Status.ErrorOccured();
App.MealViewModel.CreateWeightHistory(null);
}
else
{
Track_Weight tw = JsonConvert.DeserializeObject <Track_Weight>(response);
App.MealViewModel.CreateWeightHistory(tw.Items);
}
}
else if (rt.Equals(RequestType.UPDATE_DIET))
{
if (!err.Response.Equals("SUCCESS"))
{
//TODO Queued Requests and Retry
App.MealViewModel.Status.ErrorOccured();
}
else
{
}
String r = e.Result;
}
else if (rt.Equals(RequestType.UPDATE_FITNESS))
{
if (!err.Response.Equals("SUCCESS"))
{
//TODO Queued Requests and Retry
App.MealViewModel.Status.ErrorOccured();
}
else
{
}
String r = e.Result;
}
else if (rt.Equals(RequestType.UPDATE_WEIGHT))
{
if (!err.Response.Equals("SUCCESS"))
{
//TODO Queued Requests and Retry
App.MealViewModel.Status.ErrorOccured();
}
else
{
}
String r = e.Result;
}
RequestCnt--;
}
}
[Test] // #19
public void s()
{ //@ check taken function
User_Data ud = new User_Data();
Assert.IsTrue(ud.isUserNameTaken("a"));
}
public User_BL(User_Data dl)
{
itsDAL = dl;
}
