public async Task <HttpResponseMessage> R4_DeleteUserRole(A0003 row)
{
using (MeikoEntities db = new MeikoEntities())
{
var response = new HttpResponseMessage(HttpStatusCode.OK);
try
{
var httpRequest = HttpContext.Current.Request;
db.Configuration.LazyLoadingEnabled = false;
var a0005List = db.A0005.Where(x => x.A0002_ID == row.A0002_ID && x.A0001_ID == row.A0001_ID).ToList();
if (a0005List.Count > 0)
{
db.A0005.RemoveRange(a0005List);
}
var pq = db.A0003.FirstOrDefault(c => c.A0002_ID == row.A0002_ID && c.A0001_ID == row.A0001_ID);
if (pq != null)
{
db.A0003.Remove(pq);
}
await db.SaveChangesAsync();
return(response);
}
catch (Exception ex)
{
return(response);
}
}
}
public HttpResponseMessage R2_AddUserToRole()
{
var httpRequest = HttpContext.Current.Request;
using (MeikoEntities db = new MeikoEntities())
{
db.Configuration.LazyLoadingEnabled = false;
var response = new HttpResponseMessage(HttpStatusCode.OK);
try
{
string A0001_ID = httpRequest["A0001_ID"];
List <string> ListUser = JsonConvert.DeserializeObject <List <string> >(httpRequest["ListUser"]);
foreach (var item in ListUser)
{
var check = db.A0003.FirstOrDefault(x => x.A0001_ID == A0001_ID && x.A0002_ID == item);
if (check == null)
{
var obj = new A0003();
obj.A0003_ID = helper.GenKey();
obj.A0001_ID = A0001_ID;
obj.A0002_ID = item;
db.A0003.Add(obj);
}
}
db.SaveChanges();
return(response);
}
catch (Exception ex)
{
return(response);
}
}
}
