public List <AssignmentModel> getAllUsersInCustomFormat(String names = "")
{
var ls = new List <AssignmentModel>();
var users = new User(Db).GetAllUsers(names);
foreach (User u in users)
{
var post = new AssignmentModel(u);
ls.Add(post);
}
return(ls);
}
public void Update(String uname, AssignmentModel model)
{
string[] names = model.name.Split(" ");
Console.WriteLine("----------" + names[0]);
using var cmd = Db.Connection.CreateCommand();
cmd.CommandText = @"update user set first_name=@f,middle_name=@m,last_name=@l where username=@u;";
cmd.Parameters.Add(new MySqlParameter("@f", names[0]));
cmd.Parameters.Add(new MySqlParameter("@u", uname));
var midName = new MySqlParameter("@m", DBNull.Value);
switch (names.Length)
{
case 1:
break;
case 2:
cmd.Parameters.Add(new MySqlParameter("@l", names[1]));
break;
case 3:
midName.Value = names[1];
cmd.Parameters.AddWithValue("@l", names[2]);
break;
default:
string mid = "";
for (int i = 1; i < names.Length - 1; i++)
{
mid += names[i] + " ";
}
mid = mid.Remove(mid.LastIndexOf(" "), " ".Length).Insert(mid.LastIndexOf(" "), ""); // Remove last space
cmd.Parameters.Add(new MySqlParameter("@m", mid));
cmd.Parameters.AddWithValue("@l", names[names.Length - 1]);
break;
}
cmd.Parameters.Add(midName);
cmd.ExecuteNonQuery();
cmd.CommandText = @"update contact_number c inner join user_to_contact using(contact_id) inner join user using(user_id) inner join contact_type using(contact_type_id) set number=@num where username=@u and contact_type=@typ";
var number = new MySqlParameter("@num", model.contactDetail.Primary);
var numberType = new MySqlParameter("@typ", "Mobile");
cmd.Parameters.Add(number);
cmd.Parameters.Add(numberType);
cmd.ExecuteNonQuery();
if (!string.IsNullOrEmpty(model.contactDetail.Secondary))
{
number.Value = model.contactDetail.Secondary;
numberType.Value = "Work";
cmd.ExecuteNonQuery();
}
//string[] address = model.address.Split(",");
//string add = "";
cmd.CommandText = @"call update_address(@u,@address,@city,@state,@coun,@pin)";
cmd.Parameters.AddWithValue("@pin", model.address.PIN);
cmd.Parameters.AddWithValue("@state", model.address.State);
cmd.Parameters.AddWithValue("@city", model.address.City);
cmd.Parameters.AddWithValue("@coun", model.address.Country);
cmd.Parameters.AddWithValue("@address", model.address.AddressLine);
cmd.ExecuteNonQuery();
}