public static List <PetData> GetUserPets(int userId)
{
PetRepository petRep = new PetRepository();
KindRepository kindRep = new KindRepository();
BreedRepository breedRep = new BreedRepository();
List <PhotoData> photos = GetPhotos();
List <PetData> pets = new List <PetData>();
petRep.GetUserPets(userId).ToList().ForEach(x => pets.Add(new PetData
{
Id = x.Id,
Nickname = x.Nickname,
KindId = x.KindId,
BreedId = x.BreedId,
Kind = kindRep.Get(x.KindId).Name,
Breed = breedRep.Get(x.BreedId).Name,
Conditions = x.Conditions,
ArrivalDate = x.ArrivalDate,
Color = x.Color,
HealthStatus = x.HealthStatus,
Photos = photos.Where(k => k.PetId == x.Id).ToList()
}));
return(pets);
}
public static string fnGetOrderNum(HttpContext context, string sType)
{
KindRepository kindRepository = new KindRepository();
KindD kindD = new KindD();
kindD.KindId("O01")
.CodeId("DATE")
.CreateId(context.Session["id"].ToString());
string sNowDate = DateTime.Now.ToString("yyyyMMdd");
string sCodeDate = kindRepository.fnSelect(kindD);
if (sNowDate != sCodeDate)
{
fnSetZeroOrder();
}
kindD.CodeId(sType);
string sNowNum = kindRepository.fnSelect(kindD);
string sSql =
" UPDATE [MNDTkind_details] " +
" SET [parameter] = '" + (int.Parse(sNowNum) + 1).ToString() + "' " +
" WHERE [kind_id] = 'O01' " +
" AND [code_id] = '" + sType + "' ";
PublicApi.fnExecuteSQL(sSql, "MNDT");
return(sNowDate + fnFixOrder(sNowNum));
}
public static void RenameKind(KindData kindData)
{
KindRepository kindRep = new KindRepository();
kindRep.Update(new Kind {
Id = kindData.Id, Name = kindData.Name
});
}
public static void AddKind(string kindName)
{
KindRepository kindRep = new KindRepository();
kindRep.Create(new Kind {
Name = kindName
});
}
public CreateKindViewModel()
{
catagoryRepository = new CatagoryRepository();
KindRepository = new KindRepository();
addCommand = new RelayCommand(Add);
catagorys = catagoryRepository.Get().Select(a => new ComboBoxItem {
Text = a.Name, Value = a.Id
}).ToList();
}
public static List <KindData> GetKinds()
{
KindRepository kindRep = new KindRepository();
List <KindData> kinds = new List <KindData>();
kindRep.GetAll().ToList().ForEach(x => kinds.Add(new KindData
{
Id = x.Id,
Name = x.Name
}));
return(kinds);
}
public EditKindViewModel(Kind selectKind)
{
SelectKind = selectKind;
catagoryRepository = new CatagoryRepository();
repository = new KindRepository();
SaveCommand = new RelayCommand(UpdateKind);
ComboBoxItem = new ComboBoxItem {
Text = SelectKind.Name, Value = SelectKind.CatagoryId
};
catagorys = catagoryRepository.Get().Select(a => new ComboBoxItem {
Text = a.Name, Value = a.Id
}).ToList();
}
public OrderViewModel()
{
catagoryRepository = new CatagoryRepository();
kindRepository = new KindRepository();
OrdersRepository = new OrdersRepository();
Catagorys = catagoryRepository.Get().Select(a => new ComboBoxItem {
Text = a.Name, Value = a.Id
}).ToList();
RemoveOrder = new RelayCommand(RemoveOrderAciton);
AddToCurrentOrderCommand = new RelayCommand(AddToCurrentOrders);
SaveOrders = new RelayCommand(SaveorderAciton);
EmptyFieldsCommand = new RelayCommand(EmptyFieldsAction);
}
public ListKindsViewModel()
{
KindRepository = new KindRepository();
DeleteCommand = new RelayCommand <Kind>(DeleteKind);
EditCommand = new RelayCommand <Kind>(EditKind);
}
public static List <PetData> GetPets()
{
PetRepository petRep = new PetRepository();
KindRepository kindRep = new KindRepository();
BreedRepository breedRep = new BreedRepository();
UserRepository userRep = new UserRepository();
UserTypeRepository userTypeRep = new UserTypeRepository();
OperationRepository operRep = new OperationRepository();
List <PhotoData> photos = GetPhotos();
List <PetData> pets = new List <PetData>();
petRep.GetAll().ToList().ForEach(x => pets.Add(new PetData
{
Id = x.Id,
Nickname = x.Nickname,
KindId = x.KindId,
BreedId = x.BreedId,
Kind = kindRep.Get(x.KindId).Name,
Breed = breedRep.Get(x.BreedId).Name,
Conditions = x.Conditions,
ArrivalDate = x.ArrivalDate,
Color = x.Color,
HealthStatus = x.HealthStatus,
Photos = photos.Where(k => k.PetId == x.Id).ToList()
}));
List <OperationData> op = new List <OperationData>(operRep.GetAll().ToList().Select(x => new OperationData
{
Id = x.Id,
PetId = x.PetId,
OperationDate = x.OperationDate,
UserId = x.UserId
}));
List <UserData> users = new List <UserData>();
userRep.GetAll().ToList().ForEach(x => users.Add(new UserData
{
Id = x.Id,
Username = x.Username,
Password = x.Password,
UserType = new UserTypeData
{
Id = userTypeRep.Get(x.UserTypeId).Id,
Name = userTypeRep.Get(x.UserTypeId).Name
},
UserTypeId = x.UserTypeId,
FullName = x.FullName,
Address = x.Address,
PhoneNumber = x.PhoneNumber
}));
op.ForEach(x =>
pets.Where(p => p.Id == x.PetId).ToList()
.ForEach(pp => pp.User = users.FirstOrDefault(u => u.Id == x.UserId)));
return(pets);
}
public static void DeleteKind(KindData selectedKind)
{
KindRepository kindRep = new KindRepository();
kindRep.Delete(selectedKind.Id);
}
public DeleteKindViewModel()
{
KindRepository = new KindRepository();
DeleteCommand = new RelayCommand <int>(DeleteKind);
}
public KindController(OpvangContext context)
{
_context = context;
_repo = new KindRepository(_context);
}
