public int addmoreCustomer([FromBody] customGroup Data) { var message = 0; var list = new List <CustomerGroupUsers>(); if (Data != null) { if (Data.CustomerId != null) { foreach (var item in Data.CustomerId) { var data = new CustomerGroupUsers(); data.UserId = item; data.CustomerGroupId = Data.Id; data.IsActive = true; list.Add(data); message = 1; } } } try { db.CustomerGroupUsers.AddRange(list); db.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } return(message); }
public static CustomerGroupUsers RemoveReference(this CustomerGroupUsers item) { var obj = new CustomerGroupUsers(); if (item != null) { obj.Id = item.Id; obj.CustomerGroupId = item.CustomerGroupId; obj.UserId = item.UserId; obj.IsActive = item.IsActive; } return(obj); }
public IActionResult DeleteCust(int Id, int GroupId) { var data = new CustomerGroupUsers(); try { data = db.CustomerGroupUsers.Where(x => x.UserId == Id && x.CustomerGroupId == GroupId).FirstOrDefault(); data.IsActive = false; db.SaveChanges(); } catch (Exception e) { Console.WriteLine(e.Message); } return(Ok(data)); }
public static CustomerGroupUsers RemoveReferences(this CustomerGroupUsers item) { var obj = new CustomerGroupUsers(); obj = item.RemoveReference(); if (item.User != null) { obj.User = new User(); obj.User = item.User.RemoveReference(); } if (item.CustomerGroup != null) { obj.CustomerGroup = new CustomerGroup(); obj.CustomerGroup = item.CustomerGroup.RemoveReference(); } return(obj); }
public int createGroup([FromBody] customGroup1 formData) { var obj = new CustomerGroup(); var group = new CustomerGroupUsers(); var message = 0; try { var checkGroupName = db.CustomerGroups.Where(x => x.GroupName.ToLower() == formData.GroupName.ToLower()).FirstOrDefault(); if (checkGroupName == null) { obj.GroupName = formData.GroupName; obj.IsActive = true; db.CustomerGroups.Add(obj); db.SaveChanges(); foreach (var item in formData.CustomerId) { var check = db.CustomerGroupUsers.Where(x => x.UserId == item && x.CustomerGroupId == obj.Id).FirstOrDefault(); if (check == null) { group = new CustomerGroupUsers(); group.UserId = item; group.CustomerGroupId = obj.Id; group.IsActive = true; db.CustomerGroupUsers.Add(group); db.SaveChanges(); } } } else { message = 1; } } catch (Exception e) { Console.Write(e.Message); } return(message); }