public ActionResult DeleteMember()
{
string error = "";
var dtl = new DataTools();
var tmp = new Models.DataModels.iteam_user();
try
{
var json_string = dtl.JsonRequest();
tmp = JsonConvert.DeserializeAnonymousType(json_string, tmp);
}
catch (Exception ex)
{
error = ex.Message;
}
if (string.IsNullOrEmpty(error))
{
new Models.Member.Member().DeleteMember(tmp, ref error);
}
var output = new
{
success = string.IsNullOrEmpty(error?.Trim()),
error = error?.Trim(),
data = tmp
};
return(Content(JsonConvert.SerializeObject(output), "application/json"));
}
public void DeleteMember(Models.DataModels.iteam_user m, ref string error)
{
using (var db = new DataContext())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var user_id = m?.user_id;
db.iteam_user.RemoveRange(db.iteam_user.Where(x => x.user_id == user_id));
db.SaveChanges();
transaction.Commit();
}
catch (DbEntityValidationException ex)
{
transaction.Rollback();
error = ex.EntityValidationErrors.First().ValidationErrors.First().ErrorMessage;
}
catch (Exception ex)
{
transaction.Rollback();
error = ex.Message;
if (ex.InnerException != null)
{
error = ex.InnerException.GetBaseException().Message;
}
}
}
}
}
public void UpdateProfile(Models.DataModels.iteam_user m, ref string error)
{
using (var db = new DataContext())
{
db.ExecuteTransaction(() =>
{
var user_id = m?.user_id;
var username = m?.username.Trim();
var name_th = m?.name_th;
var email = m?.email.Trim();
var position = m?.postion;
var description = m?.description;
var phone = m?.phone.Trim();
var line_id = m?.line_id.Trim();
var path_image = m?.path_image?.Trim();
if (string.IsNullOrEmpty(name_th) || string.IsNullOrEmpty(email))
{
throw new Exception("โปรดกรอกชื่อหรืออีเมลให้ถูกต้อง");
}
var data_db = db.iteam_user.Where(x => x.user_id == user_id).FirstOrDefault();
if (data_db != null)
{
data_db.name_th = name_th;
data_db.email = email;
data_db.postion = position;
data_db.description = description;
data_db.phone = phone;
data_db.line_id = line_id;
data_db.path_image = path_image;
db.SaveChanges();
}
}, ref error);
}
}
