public static void AddAdmins(string userName, string email, string fName, string lName, DateTime birthDate, string address, string phone, string password, DateTime joinDate, decimal salary)
{
try
{
// joinDate = DateTime.Now;
// var X = DateTime.Now.Day + '-' + DateTime.Now.Month + '-' + DateTime.Now.Year;
//JoinDate = Convert.ToDateTime(JoinDate.ToShortDateString());
user us = new user()
{
userName = userName, fName = fName, lName = lName, email = email, role = Role.Admin, firstLogin = true, address = address, password = password, birthDate = birthDate, phone = phone, JoinDate = joinDate
};
us = lm.users.Add(us);
lm.SaveChanges();
//int userId = lm.users.OrderByDescending(uid => uid.id).First().id;
employee emp = new employee()
{
userId = us.id, salary = salary
};
lm.employees.Add(emp);
lm.SaveChanges();
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
public static int addMembers(UserInput user)
{
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var newuser = new user();
newuser.firstLogin = true;
newuser.isDeleted = false;
newuser.JoinDate = DateTime.Now;
//newuser.member=new member();
//newuser.member.isBlock = false;
newuser.email = user.email;
newuser.fName = user.fName;
newuser.lName = user.lName;
newuser.userName = user.userName;
newuser.password = user.userName;
newuser.birthDate = user.birthDate;
newuser.image = Convert.FromBase64String(user.profile);
newuser = lm.users.Add(newuser);
lm.SaveChanges();
newuser.member = new member();
newuser.member.isBlock = false;
lm.SaveChanges();
return(newuser.id);
}
protected void btn_update_Click(object sender, EventArgs e)
{
int id = int.Parse(lsb_employee.SelectedValue);
user updatedUser = lm.users.Single(emp => emp.id == id);
user checkupdateduser = lm.users.FirstOrDefault(emp => emp.email == txt_mail.Text && emp.id != id);
if (checkupdateduser == null)
{
user checkusername = lm.users.FirstOrDefault(emp => emp.userName == txt_username.Text && emp.id != id);
if (checkusername == null)
{
updatedUser.userName = txt_username.Text;
updatedUser.email = txt_mail.Text;
updatedUser.fName = txt_fname.Text;
updatedUser.lName = txt_lname.Text;
updatedUser.birthDate = DateTime.Parse(txt_birthdate.Text);
updatedUser.address = txt_address.Text;
updatedUser.phone = txt_phone.Text;
lm.SaveChanges();
}
else
{
lbl_hint1.Text = "User Name already exist";
}
}
else
{
lbl_hint2.Text = "Mail already exist ";
}
}
protected void btn_update_Click(object sender, EventArgs e)
{
if (IsValid)
{
String title = txt_title.Text;
int nOfCopies = int.Parse(txt_noofcopies.Text);
int avilable = int.Parse(txt_available.Text);
String des = txt_desc.Text;
int id = int.Parse(lbl_id.Text);
var checkBook = lm.books.SingleOrDefault(bo => bo.title == title && bo.id != id);
if (checkBook == null)
{
var updBook = lm.books.SingleOrDefault(bo => bo.id == id);
updBook.title = title;
updBook.availableCopies = avilable;
updBook.copiesCount = nOfCopies;
updBook.source = des;
lm.SaveChanges();
var bookList = lm.books.Where(bo => bo.isDeleted != true).ToList();
lb_books.DataSource = bookList;
lb_books.DataTextField = "title";
lb_books.DataValueField = "id";
lb_books.DataBind();
}
}
}
protected void gv_Admin_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
int id = (int)gv_Admin.DataKeys[e.RowIndex].Value;
lm.users.Single(u => u.id == id).isDeleted = true;
gv_Admin.DataSource = lm.users.Where(u => u.role == Role.Admin && u.isDeleted == false).Select(u => new { u.id, u.userName, u.email, u.fName, u.lName, u.JoinDate, u.phone, u.employee.salary }).ToList();
gv_Admin.DataBind();
lm.SaveChanges();
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
protected void btn_ChangePassword_Click(object sender, EventArgs e)
{
try
{
if (IsValid)
{
if (Session["userId"] != null)
{
int userId = int.Parse(Session["userId"].ToString());
var data = lm.users.Single(pw => pw.id == userId);
if (txt_Oldpass.Text == data.password)
{
data.password = txt_NewPass.Text;
lm.SaveChanges();
}
Response.Redirect("~/User/Login.aspx");
}
else
{
Response.Redirect("~/User/Login.aspx");
}
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
public static int addBorrow(int bookId, int userId)
{
LibararyModel lm = new LibararyModel();
var check = lm.userBook.Where(x => x.userId == userId && x.bookId == bookId &&
x.isDelivered == false && x.status == BookStatus.isborrowking
).Count();
if (check == 0)
{
var book = lm.books.FirstOrDefault(x => x.id == bookId);
book.availableCopies--;
var z = lm.userBook.Add(new userBook
{
employeeId = 2,//session
bookId = bookId,
userId = userId,
startDate = DateTime.Now,
status = BookStatus.isborrowking,
isDelivered = false,
deliveredDate = DateTime.Now.AddDays(7),
});
lm.SaveChanges();
return(z.id);
}
return(-1);
}
public static string deleteMembers(string userName)
{
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var user = lm.users.Where(x => x.userName == userName).FirstOrDefault();
user.isDeleted = true;
lm.SaveChanges();
return(user.isDeleted.ToString());
}
protected void btn_update_Click(object sender, EventArgs e)
{
if (IsValid)
{
string Email = txt_mail.Text;
string Fname = txt_fname.Text;;
string Lname = txt_lname.Text;
string Birthdate = txt_birthdate.Text;
string Address = txt_address.Text;
string Phone = txt_phone.Text;
string userName = txt_username.Text;
user checkemail = lm.users.FirstOrDefault(emp => emp.email == Email);
if (checkemail == null)
{
user checkeuser = lm.users.FirstOrDefault(emp => emp.userName == userName);
if (checkeuser == null)
{
user u = new user();
u.role = Role.Employee;
u.email = Email;
u.fName = Fname;
u.lName = Lname;
u.birthDate = DateTime.Parse(Birthdate);
u.address = Address;
u.phone = Phone;
u.userName = userName;
u.isDeleted = false;
u.JoinDate = DateTime.Now;
lm.users.Add(u);
lm.SaveChanges();
Response.Redirect("ViewProfile.aspx");
}
else
{
lbl_hint2.Text = "This User Name already exist please choose another one ";
}
}
else
{
lbl_hint.Text = "This Email already exist please insert another Email ";
}
}
}
public static string UpdateData(string fname)//, string lname, string email, string add, string id)
{
using (LibararyModel db = new LibararyModel())
{
int eid = 0; //int.Parse(id); // will come from login session
var q1 = db.users.Single(emp => emp.id == eid);
q1.fName = fname;
//q1.lName = lname;
//q1.email = email;
//q1.address = add;
db.SaveChanges();
}
return("submit");
}
protected void btn_addbook_Click(object sender, EventArgs e)
{
string Title = txt_title.Text;
string Author = ddl_author.SelectedValue;
string Publisher = ddl_publisher.SelectedValue;
DateTime PublishingDate = DateTime.Parse(txt_pubdate.Text);
string Category = ddl_category.SelectedValue;
int Edition = int.Parse(txt_edition.Text);
//int Pages = int.Parse(txt_pages.Text);
int NoOfCopies = int.Parse(txt_noofcopies.Text);
int Available = NoOfCopies;
string Description = txt_desc.Text;
book checkebook = lm.books.FirstOrDefault(b => b.title == Title);
if (checkebook == null)
{
book b = new book();
b.title = Title;
b.name = Title;
b.autherId = int.Parse(Author);
b.publisherId = int.Parse(Publisher);
b.publishDate = (PublishingDate);
b.categoryName = Category;
b.copiesCount = NoOfCopies;
b.source = Description;
b.availableCopies = Available;
b.isDeleted = false;
b.joinDate = DateTime.Now;
lm.books.Add(b);
lm.SaveChanges();
txt_desc.Text = "";
txt_edition.Text = "";
txt_noofcopies.Text = "";
txt_pubdate.Text = "";
txt_title.Text = "";
}
else
{
}
}
public static string blockMembers(string userName)
{
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var member = lm.members.Where(x => x.user.userName == userName).FirstOrDefault();
if (member.isBlock)
{
member.isBlock = false;
member.endDate = null;
}
else
{
member.isBlock = true;
member.endDate = DateTime.Now.AddDays(7);
}
lm.SaveChanges();
return(member.isBlock.ToString());
}
public void SendMail(string MailTo)
{
MailMessage mail = new MailMessage();
mail.To.Add(new MailAddress(MailTo));
mail.From = new MailAddress("*****@*****.**");
mail.Subject = "new Password";
//Generate a new password
//string NewPassword = System.Web.Security.Membership.GeneratePassword(8, 3);
// store that password in the user's info so they can use it during next login
int userid = int.Parse(Session["userId"].ToString());
user selected = lm.users.SingleOrDefault(u => u.id == userid);
int NewPassword = 1234;
string Body = "Your new password is: " + NewPassword;
mail.Body = Body;
selected.password = NewPassword.ToString();
lm.SaveChanges();
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com"; //Or Your SMTP Server Address
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "password");
//Or your Smtp Email ID and Password
smtp.EnableSsl = true;
smtp.Send(mail);
}
protected void btn_return_Click(object sender, EventArgs e)
{
var returnStatus = (BookStatus)Convert.ToInt32(rbtnl_returnType.SelectedValue);
var bookId = 0;
var userId = 0;
if (ddl_Returnbooks.SelectedValue != "" && ddl_ReturnUsers.SelectedValue != "")
{
bookId = Convert.ToInt32(ddl_Returnbooks.SelectedValue);
userId = Convert.ToInt32(ddl_ReturnUsers.SelectedValue);
}
else
{
return;
}
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var todayDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
if (bookId > 0 & userId > 0)
{
if (returnStatus == BookStatus.isReading)
{
var book = lm.userBook.Where(x => x.status == returnStatus && x.startDate == todayDate &&
x.startDate == todayDate &&
x.isDelivered == false &&
x.bookId == bookId && x.userId == userId)
.FirstOrDefault();
var returnedBook = lm.books.FirstOrDefault(x => x.id == bookId);
returnedBook.availableCopies++;
book.isDelivered = true;
book.returnDate = DateTime.Now;
lm.SaveChanges();
var books = lm.userBook.Where(x => x.status == returnStatus && x.startDate == todayDate &&
x.startDate == todayDate &&
x.isDelivered == false)
.Select(x => new userBookDto {
book = x.book, bookId = x.bookId
}).ToList();
books = books.Distinct().ToList();
ddl_Returnbooks.DataSource = books;
ddl_Returnbooks.DataTextField = "bookTitle";
ddl_Returnbooks.DataValueField = "bookId";
ddl_Returnbooks.DataBind();
ddl_Returnbooks_SelectedIndexChanged(null, null);
}
else
{
var book = lm.userBook.Where(x => x.status == returnStatus &&
x.isDelivered == false &&
x.bookId == bookId && x.userId == userId)
.FirstOrDefault();
book.isDelivered = true;
book.returnDate = DateTime.Now;
var returnedBook = lm.books.FirstOrDefault(x => x.id == bookId);
returnedBook.availableCopies++;
lm.SaveChanges();
var books = lm.userBook.Where(x => x.status == returnStatus &&
x.isDelivered == false)
.Select(x => new userBookDto {
book = x.book, bookId = x.bookId
}).ToList();
books = books.Distinct().ToList();
ddl_Returnbooks.DataSource = books;
ddl_Returnbooks.DataTextField = "bookTitle";
ddl_Returnbooks.DataValueField = "bookId";
ddl_Returnbooks.DataBind();
ddl_Returnbooks_SelectedIndexChanged(null, null);
}
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (IsValid)
{
if (Session["userId"] != null)
{
int id = (int)Session["userId"];
user us = libModel.users.Single(u => u.id == id);
//employee emp = libModel.employees.Single(em => em.userId == us.id);
var query = libModel.users.Where(q => q.userName == txt_UserName.Text).Count();
var query1 = libModel.users.Where(q1 => q1.email == txt_Email.Text).Count();
var query2 = libModel.users.Where(q2 => q2.phone == txt_Phone.Text).Count();
if (query == 0 || txt_UserName.Text == us.userName)
{
if (query1 == 0 || txt_Email.Text == us.email)
{
if (query2 == 0 || txt_Phone.Text == us.phone)
{
us.userName = txt_UserName.Text;
us.email = txt_Email.Text;
us.fName = txt_Fname.Text;
us.lName = txt_Lname.Text;
us.address = txt_Address.Text;
us.phone = (txt_Phone.Text);
//string path = "~/Image/" + fu_Image.FileName;
//fu_Image.SaveAs(Server.MapPath(path));
string filename = System.IO.Path.GetFileName(fu_Image.FileName);
fu_Image.PostedFile.SaveAs(Server.MapPath("Image/" + filename));
System.Drawing.Image img = System.Drawing.Image.FromFile(Server.MapPath("Image/" + filename));
byte[] path = imgToByteArray(img);
us.image = path;
libModel.SaveChanges();
lbl_Status.Text = "Save Success";
Response.Redirect("~/admin/ShowProfileBasicAdmin.aspx");
}
else
{
lbl_ValidPhone.Text = "Phone is Valid";
}
}
else
{
lbl_ValidEmail.Text = "Email is Valid";
}
}
else
{
lbl_ValidUserName.Text = "UserName is Valid";
}
}
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
protected void btn_login_Click1(object sender, EventArgs e)
{
// to handel the error
try
{
if (Session["userId"] != null)
{
int userId = int.Parse(Session["userId"].ToString());
var data = lm.users.Single(pw => pw.id == userId);
if (txt_Oldpass.Text == data.password)
{
txt_Oldpass.Text = data.password; //put the old pass in the text
data.password = txt_NewPass.Text; // put the new one in the next text
lm.SaveChanges();
}
// if the pass u entered didnt match the pass in the database
else
{
lbl_Message.Text = " You Intered an Invalid Password ";
}
}
else if (Session["FirstLogin"] != null)
{
int userId = int.Parse(Session["FirstLogin"].ToString());
var data = lm.users.Single(pw => pw.id == userId);
data.password = txt_NewPass.Text; // put the new one in the next text
data.firstLogin = false; // put the new one in the next text
lm.SaveChanges();
Session["FirstLogin"] = null;
Session.Add("userId", data.id);
Session.Add("username", data.userName);
//lbl_result.Text = "welcome";
if (data.role != null)
{
Response.Redirect("~/admin/ShowProfileBasicAdmin.aspx");
}
else
{
Response.Redirect("~/User/Profile.aspx");
}
}
// if there is no session
else
{
Response.Redirect("~/User/Login.aspx");
}
}
//catch the error
catch (Exception ex)
{
//Response.Redirect("~/ErrorPage/error.aspx");
//Console.WriteLine(ex.Message);
//Console.WriteLine(" u did something wrong");
}
}
