public static List <OtakimDTO> GetOtakim()
{
using (libraryEntities db = new libraryEntities())
{
return(Converters.OtekConverter.ConvertOtakimListToDTO(db.Otakims.ToList()));
}
}
public static List <WorkerDTO> GetWorkers()
{
using (libraryEntities db = new libraryEntities())
{
return(Converters.WorkerConverter.ConvertWorkerListToDTO(db.Workers.Where(a => a.status == true).ToList()));
}
}
public JsonResult checkLogin(string number, string password)
{
bool result;
libraryEntities db = new libraryEntities();
var num1 = db.Member_Message.Where(s => s.number == number).FirstOrDefault();
var num2 = db.Member_Message.Where(s => s.code == password).FirstOrDefault();
if (num1 != null && num2 != null)
{
// HttpSession session = Request.getSession();
result = true;
Session["userName"] = num1.name;
Session["userNum"] = num1.number;
Session["userPass"] = num2.code;
Session["userSex"] = num2.sex;
Session["userCnt"] = num2.BorBook_Cnt;
Session["userBook"] = num2.Borrow_Book;
Session.Timeout = 30;
}
else
{
result = false;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public static List <CategoryDTO> GetCategorys()
{
using (libraryEntities db = new libraryEntities())
{
return(Converters.categoriesConverter.ConvertCategoryListToDTO(db.Categories.ToList()));
}
}
public static List <BookDTO> GetBooks()
{
using (libraryEntities db = new libraryEntities())
{
return(Converters.BookConverter.ConvertBookListToDTO(db.Books.Where(a => a.isDeleted == false).ToList()));
}
}
public static bool addotek(int codeB, int amount, double priceO, int numOt)
{
using (libraryEntities db = new libraryEntities())
{
for (int i = numOt - amount + 1; i <= numOt; i++)
{
db.Otakims.Add(new Otakim
{
codeBook = codeB,
Serial = i,
price = Convert.ToInt32(priceO),
status = "נמצא"
});
}
try
{
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public static List <SubsciberDTO> GetSubscibers()
{
using (libraryEntities db = new libraryEntities())
{
return(Converters.SubsriberConverter.ConvertSubscriberListToDTO(db.Subscribers.Where(a => a.isDeleted == false).ToList()));
}
}
public static bool updateSubsciber(SubsciberDTO a)
{
using (libraryEntities db = new libraryEntities())
{
Subscriber au = db.Subscribers.First(x => x.id == a.id);
au.firstName = a.firstName;
au.lastName = a.lastName;
au.id = a.id;
au.isDeleted = a.isDeleted;
au.address = a.address;
au.phon = a.phon;
au.startDate = a.startDate;
au.type = a.type;
au.email = a.email;
try
{
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public ActionResult Index()
{
using (libraryEntities library = new libraryEntities())
{
return(View());
}
}
public static List <LendingDTO> GetLendings()
{
using (libraryEntities db = new libraryEntities())
{
return(Converters.LendingConverter.ConvertLendingListToDTO(db.Lendings.ToList()));
}
}
public static List <SubscriptionTypeDTO> GetSubscriptionTypes()
{
using (libraryEntities db = new libraryEntities())
{
return(Converters.SubsciptionTypeConverter.ConvertSubsciptionTypeListToDTO(db.SubscriptionTypes.ToList()));
}
}
public static bool addWorker(WorkerDTO s)
{
using (libraryEntities db = new libraryEntities())
{
string mailBody = $" Hi " + s.name + " You have successfully joined our team \n " +
$"your password is " + s.password + " \n Thanks ";
if (db.Workers.FirstOrDefault(x => x.idWorker == s.idWorker) != null)
{
s.status = true;
updateWorker(s);
}
else
{
db.Workers.Add(Converters.WorkerConverter.ConvertWorkerDTOToDAL(s));
//bool b = SendMail(s.address, "ברוכים הבאים לצוות עובדנו", mailBody);
}
try
{
db.SaveChanges();
bool b = SendMail(s.address, "ברוכים הבאים לצוות עובדנו", mailBody);
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public static bool updateWorker(WorkerDTO a)
{
using (libraryEntities db = new libraryEntities())
{
Worker au = db.Workers.First(x => x.idWorker == a.idWorker);
au.name = a.name;
au.status = a.status;
au.address = a.address;
au.phone = a.phone;
au.password = a.password;
au.typeWork = a.typeWork;
try
{
db.SaveChanges();
bool b = SendMail(a.name, "ברוכים הבאים לצוות עובדנו", "פרטיך עודכנו בהצלחה במערכת ");
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public static List <CrowdDTO> GetCrowds()
{
using (libraryEntities db = new libraryEntities())
{
return(Converters.CrowdConverter.ConvertCrowdListToDTO(db.Crowds.ToList()));
}
}
public static List <AuthorDTO> GetAuthor()
{
using (libraryEntities db = new libraryEntities())
{
return(Converters.AuthorConverter.ConvertAuthorListToDTO(db.Aauthors.ToList()));
}
}
// GET: Character/Characters
public ActionResult Index(int id)
{
using (libraryEntities db = new libraryEntities())
{
var model = new CharacterModel(id);
return(View(model));
}
}
public static List <SubsciberDTO> GetSubscibersById(int code)
{
using (libraryEntities db = new libraryEntities())
{
List <SubsciberDTO> t = Converters.SubsriberConverter.ConvertSubscriberListToDTO(db.Subscribers.Where(x => x.id == code).ToList());
return(t);
}
}
public static List <OtakimDTO> GetOtakimByCodeBook(int code)
{
using (libraryEntities db = new libraryEntities())
{
List <OtakimDTO> t = Converters.OtekConverter.ConvertOtakimListToDTO(db.Otakims.Where(x => x.codeBook == code).ToList());
return(t);
}
}
private void getAbilitiesList(int id, libraryEntities db)
{
abilities = (from ability in db.Abilities
join characters in db.CharacterAbilities
on ability.Id equals characters.AbilityID
where characters.CharacterID == id
select ability).ToList();
}
public static List <WorkerDTO> GetWorkerById(int code)
{
using (libraryEntities db = new libraryEntities())
{
List <WorkerDTO> t = Converters.WorkerConverter.ConvertWorkerListToDTO(db.Workers.Where(x => x.idWorker == code).ToList());
return(t);
}
}
public Form2()
{
_database = new libraryEntities();
InitializeComponent();
List <Genre> genres = _database.Genre.ToList();
comboBoxGenre2.DataSource = genres;
comboBoxGenre2.DisplayMember = "genrename";
}
public SearchForm()
{
_database = new libraryEntities();
InitializeComponent();
List <Genre> genres = _database.Genre.ToList();
List <AuthorLovesGenres> data = null;
comboBox1.DataSource = genres;
comboBox1.DisplayMember = "genrename";
}
private void getInventoryLists(int id, libraryEntities db)
{
equipment = db.Inventories.Where(i =>
i.CharacterID == id && i.Type == "Equipment").ToList();
artifacts = db.Inventories.Where(i =>
i.CharacterID == id && i.Type == "Artifact").ToList();
oddities = db.Inventories.Where(i =>
i.CharacterID == id && i.Type == "Oddity").ToList();
}
private void getSkillLists(int id, libraryEntities db)
{
mightSkills = db.Skills.Where(s =>
s.CharacterID == id && s.Type == "Might").ToList();
speedSkills = db.Skills.Where(s =>
s.CharacterID == id && s.Type == "Speed").ToList();
intellectSkills = db.Skills.Where(s =>
s.CharacterID == id && s.Type == "Intellect").ToList();
}
public static newLendingDitaile GetLendingItems()
{
using (libraryEntities db = new libraryEntities())
{
Lending l = db.Lendings.ToList().Last();
List <LendingItemDTO> s = Converters.LendingItemConverter.ConvertLendingItemListToDTO(db.LendingItems.ToList());
newLendingDitaile le = new newLendingDitaile();
le.code = l.codeLending;
le.lendingItemsToSub = (s.Where(x => x.idSUB == l.idSubscribers && x.returnDate == null).ToList());
return(le);
}
}
public CharacterModel(int id)
{
using (libraryEntities db = new libraryEntities())
{
characterData = db.Characters.Where(c => c.Id == id).First();
advancementData = db.Advancements.Where(a => a.CharacterID == id).ToList();
cyphers = db.Cyphers.Where(c => c.CharacterID == id).ToList();
getSkillLists(id, db);
getInventoryLists(id, db);
getAbilitiesList(id, db);
}
}
public static LendingItemDTO ConvertLendingItemToDTO(LendingItem lendingItem)
{
using (libraryEntities db = new libraryEntities())
{
return(new LendingItemDTO
{
codeLending = lendingItem.codeLending,
codeOtek = lendingItem.codeOtek,
idSUB = Convert.ToInt32(lendingItem.Lending.idSubscribers),
comment = lendingItem.comment,
returnDate = lendingItem.returnDate,
bookName = db.Books.First(b => b.codeBook == lendingItem.Otakim.codeBook).name
});
}
}
public static bool addAuther(AuthorDTO a)
{
using (libraryEntities db = new libraryEntities())
{
db.Aauthors.Add(Converters.AuthorConverter.ConvertAuthorDTOToDAL(a));
try
{
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public static bool addLending(LendingDTO l)
{
using (libraryEntities db = new libraryEntities())
{
db.Lendings.Add(Converters.LendingConverter.ConvertLendingDTOToDAL(l));
try
{
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public static bool addCrowd(CrowdDTO c)
{
using (libraryEntities db = new libraryEntities())
{
db.Crowds.Add(Converters.CrowdConverter.ConvertCrowdDTOCToDAL(c));
try
{
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
