private void btnxoa_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Bạn có muốn xóa", "Thông báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
dataDataContext db = new dataDataContext();
string ser = txtMaDocGia.Text;
var Lst = (from s in db.HoiViens where s.MaHV == ser select s).First();
try
{
db.HoiViens.DeleteOnSubmit(Lst);
db.SubmitChanges();
MessageBox.Show("Đã xóa", "Thông báo", MessageBoxButtons.OK);
reload();
}
catch
{
MessageBox.Show("Xảy ra lỗi", "Thông báo", MessageBoxButtons.OK);
}
//do something
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
private void load()
{
dataDataContext db = new dataDataContext();
var ct = (from s in db.ctpms where s.MaPM == ma orderby s.MaCTPM select s).ToList();
dataGridView1.DataSource = ct;
}
private void load()
{
dataDataContext db = new dataDataContext();
var Lst = from s in db.TheLoais select s;
comboTheLoai.DataSource = Lst.ToList();
comboTheLoai.DisplayMember = "TenTL";
comboTheLoai.ValueMember = "MaTL";
var sach = from s in db.ThongTinSaches select s.MaS.Substring(1);
var lssach = from s in db.ThongTinSaches select s;
dataGridView1.DataSource = lssach.ToList();
int m = 0;
foreach (string x in sach)
{
int k = int.Parse(x);
if (k > m)
{
m = k;
}
}
int a = m + 1;
txtMaSach.Text = "S" + a.ToString();
txtmanxb.Text = "NXB";
txtNXB.Text = "";
txtTenSach.Text = "";
txtNamXB.Text = "";
txtmatg.Text = "TG";
txtTacGia.Text = "";
}
private void btnsua_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Bạn có muốn sửa", "Thông báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
dataDataContext db = new dataDataContext();
string ser = txtMaSach.Text;
var sa = (from s in db.Saches where s.MaS == ser select s).First();
sa.MaTG = txtmatg.Text;
sa.MaTl = comboTheLoai.SelectedValue.ToString();
sa.TenSach = txtTenSach.Text;
sa.NamXuatBan = int.Parse(txtNamXB.Text);
sa.MaNXB = txtmanxb.Text;
try
{
db.SubmitChanges();
MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK);
load();
clear();
}
catch {
MessageBox.Show("lỗi", "Thông báo", MessageBoxButtons.OK);
}
//do something
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
private void add()
{
try
{
dataDataContext db = new dataDataContext();
Sach s = new Sach();
s.MaS = txtMaSach.Text;
s.MaTG = txtmatg.Text;
s.MaTl = comboTheLoai.SelectedValue.ToString();
s.TenSach = txtTenSach.Text;
s.NamXuatBan = int.Parse(txtNamXB.Text);
s.MaNXB = txtmanxb.Text;
s.TinhTrang = true;
db.Saches.InsertOnSubmit(s);
db.SubmitChanges();
// MessageBox.Show(hv.MaHV.ToString() + hv.GioiTinh.ToString() + hv.NgaySinh.ToString() + hv.NgayLapThe.ToString() + hv.MaLoaiHV.ToString());
MessageBox.Show("Thêm thành công");
load();
clear();
}
catch (Exception ex)
{
MessageBox.Show("xay ra loi", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected void GridView2_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
//string ah = GridView2.SelectedRow.Cells[1].Text;
int I = e.NewSelectedIndex;
// GridViewRow row = GridView2.SelectedRow;
// string lo = row.ID;
string pid = GridView2.Rows[I].Cells[1].Text;
dataDataContext dd = new dataDataContext();
Word_search word = new Word_search();
var eddd = (from a in dd.Word_searches
where a.ID == Convert.ToInt32(pid)
select a).SingleOrDefault();
GMap1.Visible = true;
GMap1.reset();
PinIcon p;
GMarker gm;
GInfoWindow gin;
GLatLng mainarea = new GLatLng(Convert.ToDouble(eddd.latid), Convert.ToDouble(eddd.@long));
GMap1.setCenter(mainarea, 15);
XPinLetter xpinletter = new XPinLetter((PinShapes.pin_star), "W", Color.Blue, Color.White, Color.Chocolate);
GMap1.Add(new GMarker(mainarea, new GIcon(xpinletter.ToString(), xpinletter.Shadow())));
p = new PinIcon(PinIcons.computer, Color.Cyan);
gm = new GMarker(new GLatLng(Convert.ToDouble(eddd.latid), (Convert.ToDouble(eddd.@long))), new GMarkerOptions(new GIcon(p.ToString(), p.Shadow())));
gin = new GInfoWindow(gm, "<font color=black><b>Search info</b><br/> Word search:" + eddd.Word_search1 + "<br /> date_of_search:" + eddd.date_s, false, GListener.Event.mouseover);
GMap1.Add(gin);
Session["lat"] = this.Request.QueryString["lat"];
Session["lon"] = this.Request.QueryString["long"];
Session["user"] = us;
}
private void btnsua_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Bạn có muốn sửa", "Thông báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
dataDataContext db = new dataDataContext();
string ser = txtmatacgia.Text;
var sa = (from s in db.TacGias where s.MaTG == ser select s).First();
sa.TenTg = txttentg.Text;
try
{
db.SubmitChanges();
MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK);
reload();
}
catch
{
MessageBox.Show("lỗi", "Thông báo", MessageBoxButtons.OK);
}
//do something
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
private void reload()
{
dataDataContext db = new dataDataContext();
var Lst1 = (from s in db.NhanViens select s).ToList();
var Lst = (from s in db.NhanViens select s.MaNv.Substring(2)).ToList();
// ListViewItem ls = new ListViewItem();
dataGridView1.DataSource = Lst1;
int m = 0;
foreach (string x in Lst)
{
int k = int.Parse(x);
if (k > m)
{
m = k;
}
}
int a = m + 1;
txtManv.Text = "NV" + a.ToString();
var lst2 = (from s in db.TaiKhoans select s).ToList();
int max2 = lst2.Max(r => r.userid);
txtuserid.Text = (max2 + 1).ToString();
txttk.Text = "";
txtmk.Text = "";
txtmk2.Text = "";
}
private void bunifuImageButton3_Click(object sender, EventArgs e)
{
dataDataContext db = new dataDataContext();
var kt = (from s in db.ctpms where s.ThoiGianMuon == datengaymuon.Value.Date && s.MaHV == txtmadg.Text select s).ToList();
toida = kt.Count();
var Lst = (from s in db.HoiViens where s.MaHV.Contains(txtmadg.Text) select s).ToList();
if (Lst.Count > 0)
{
txttendg.Text = Lst[0].TenHoiVien.ToString();
// txttennxb.Text = Lst[0].TenNXB.ToString();
}
else
{
MessageBox.Show("Không tìm thấy ");
load();
}
MessageBox.Show("Số sách đã mượn hôm nay : " + toida.ToString());
var sachdamuon = (from s in db.ctpms where s.MaHV == txtmadg.Text select s).ToList();
List <ctpm> list3 = new List <ctpm>();
foreach (ctpm a in sachdamuon)
{
list3.Add(a);
}
dataGridView1.DataSource = list3;
}
private void btnthem_Click(object sender, EventArgs e)
{
if (txttendg.Text != "")
{
if (txttensach.Text != "")
{
dataDataContext db = new dataDataContext();
var Lst = (from s in db.ChiTietPhieuMuons select s).ToList();
if (toida + 1 > rbsosachtoida)
{
MessageBox.Show("Số sách mượn đã vượt quá quy định", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
toida = toida + 1;
mactpm = mactpm + 1;
// ListViewItem ls = new ListViewItem();
add_to_data();
hienthi();
txttensach.Text = "";
txtmas.Text = "S";
}
}
else
{
MessageBox.Show("Vui lòng cho biết tên sách", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Vui lòng cho biết tên đọc giả", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void login()
{
dataDataContext db = new dataDataContext();
string user = txtten.Text;
string pass = txtmk.Text;
if (user != "" && pass != "")
{
var userid = (from s in db.TaiKhoans where s.pass == pass && s.tentk == user select s.userid).First();
if (userid != 0)
{
Main main = new Main(userid);
main.Show();
this.Hide();
}
else
{
dem++;
MessageBox.Show("Tài khoản hoặc mật khẩu gặp vấn đề", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
if (dem >= 3)
{
MessageBox.Show("Bạn đã đăng nhập sai vượt số lần cho phép", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}
}
else
{
MessageBox.Show("Cần nhập đầy đủ thông tin", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
int I = e.NewSelectedIndex;
kk = GridView1.Rows[I].Cells[1].Text;
dataDataContext dd = new dataDataContext();
User ddd = new User();
ddd = (from a in dd.Users
where a.ID == Convert.ToInt32(kk)
select a).SingleOrDefault();
var sw = (from bb in data.Word_searches
where bb.Searcher_id == Convert.ToInt32(kk)
select new
{
bb.ID,
bb.Word_search1,
bb.latid,
bb.@long,
bb.Searcher_id,
});
GridView2.DataSource = sw;
GridView2.DataBind();
Session["lat"] = this.Request.QueryString["lat"];
Session["lon"] = this.Request.QueryString["long"];
Session["user"] = us;
}
private void btnthem_Click(object sender, EventArgs e)
{
try
{
if (txttennxb.Text == "")
{
MessageBox.Show("Nhập tên nhà sản xuất", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
dataDataContext db = new dataDataContext();
NhaXuatBan nxb = new NhaXuatBan();
nxb.MaNXB = txtmanxb.Text;
nxb.TenNXB = txttennxb.Text;
db.NhaXuatBans.InsertOnSubmit(nxb);
db.SubmitChanges();
//dataGridView1.DataSource = null ;
txttennxb.Text = "";
reload();
MessageBox.Show("Thêm thành công");
}
}
catch (Exception ex)
{
MessageBox.Show("xay ra loi", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmThongKeNhanVien_Load(object sender, EventArgs e)
{
dataDataContext db = new dataDataContext();
var Lst = (from s in db.NhanViens select s).ToList();
lbltong.Text = Lst.Count.ToString();
}
private void btnluu_Click(object sender, EventArgs e)
{
try{
dataDataContext db = new dataDataContext();
var mas = (from s in db.ChiTietPhieuMuons where s.MaCTPM == mactpm select s.MaS).First().ToString();
var tt = (from s in db.ChiTietPhieuMuons where s.MaCTPM == mactpm select s).First();
if (tt.TinhTrang == true)
{
MessageBox.Show("Sách đã được trả");
}
else
{
tt.TinhTrang = true;
db.SubmitChanges();
dataDataContext db1 = new dataDataContext();
var sach = (from s in db1.Saches where s.MaS == mas orderby s.MaS select s).First();
sach.TinhTrang = true;
db1.SubmitChanges();
MessageBox.Show("Hoàn thành");
load();
}
}
catch (Exception ex) {
MessageBox.Show(ex.ToString());
MessageBox.Show("Xảy ra lỗi", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Main_Load(object sender, EventArgs e)
{
dataDataContext db = new dataDataContext();
var Lst = (from s in db.TaiKhoans where s.userid == id select s).ToList();
// ListViewItem ls = new ListViewItem();
dataDataContext db1 = new dataDataContext();
int us = Lst[0].userid;
var Lst2 = (from s in db1.NhanViens where s.userid == us select s).ToList();
if (Lst[0].role.ToString() == "True")
{
danhMụcNhânViênToolStripMenuItem.Enabled = true;
quảnLýCácRàngBuộcToolStripMenuItem1.Enabled = true;
thốngKêToolStripMenuItem.Enabled = true;
quảnLýDanhMụcTàiKhoảnToolStripMenuItem.Enabled = true;
toolStripButton5.Enabled = true;
toolStripLabel5.Enabled = true;
MessageBox.Show("Xin Chao " + Lst2[0].TenNv.ToString() + "\nChức vụ admin", "\nChức vụ admin");
}
else
{
MessageBox.Show("Xin Chao " + Lst2[0].TenNv.ToString() + "\nChức vụ user", "\nChức vụ user");
}
// MessageBox.Show(Lst[0].role.ToString());
frmThongKePhieuMuon ds = new frmThongKePhieuMuon();
ds.MdiParent = this;
ds.Show();
}
private void btnxoa_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Bạn có muốn xóa", "Thông báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
dataDataContext db = new dataDataContext();
var Lst = (from s in db.ChiTietPhieuMuons where s.MaCTPM == mact select s).First();
try
{
//MessageBox.Show(Lst.MaS);
db.ChiTietPhieuMuons.DeleteOnSubmit(Lst);
db.SubmitChanges();
MessageBox.Show("Đã xóa", "Thông báo", MessageBoxButtons.OK);
load();
}
catch
{
MessageBox.Show("Xảy ra lỗi", "Thông báo", MessageBoxButtons.OK);
}
//do something
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
private void btnthem_Click(object sender, EventArgs e)
{
try
{
if (txttentg.Text == "")
{
MessageBox.Show("Nhập tên tác giả", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
dataDataContext db = new dataDataContext();
TacGia tg = new TacGia();
tg.MaTG = txtmatacgia.Text;
tg.TenTg = txttentg.Text;
db.TacGias.InsertOnSubmit(tg);
db.SubmitChanges();
//dataGridView1.DataSource = null ;
txttentg.Text = "";
reload();
MessageBox.Show("Thêm thành công");
}
}
catch (Exception ex)
{
MessageBox.Show("xay ra loi", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void load()
{
dataDataContext db = new dataDataContext();
var Lst = from s in db.TheLoais select s;
comboTheLoai.DataSource = Lst.ToList();
comboTheLoai.DisplayMember = "TenTL";
comboTheLoai.ValueMember = "MaTL";
}
public static void InsertProperties(List <Property> p)
{
dataDataContext dataDataContext = new dataDataContext(StaticCalls.ConnectionString);
foreach (Property item in p)
{
dataDataContext.Properties.InsertOnSubmit(item);
}
dataDataContext.SubmitChanges();
}
private void frmRangBuoc_Load(object sender, EventArgs e)
{
dataDataContext db = new dataDataContext();
var Lst = (from s in db.RangBuocs select s).ToList();
gtrb1.Text = Lst[0].GiaTri.ToString();
gtrb2.Text = Lst[1].GiaTri.ToString();
rb1.Text = Lst[0].Tenrb.ToString();
rb2.Text = Lst[1].Tenrb.ToString();
}
private void frmThongKeSach_Load(object sender, EventArgs e)
{
dataDataContext db = new dataDataContext();
var Lst = (from s in db.Saches select s).ToList();
var sachchomuon = (from s in db.Saches where s.TinhTrang == false select s).ToList();
lbltong.Text = Lst.Count.ToString();
lblmuon.Text = sachchomuon.Count.ToString();
lbltrue.Text = (Lst.Count - sachchomuon.Count).ToString();
}
private void reload()
{
dataDataContext db = new dataDataContext();
var Lst = (from s in db.NhaXuatBans select s).ToList();
//DataGridViewRow r = new DataGridViewRow();
dataGridView1.DataSource = Lst;
int counttg = Lst.Count() + 1;
txtmanxb.Text = "NXB" + counttg.ToString();
}
private void frmThongKePhieuMuon_Load(object sender, EventArgs e)
{
dataDataContext db = new dataDataContext();
var ds = (from s in db.mains where s.ThoiGianMuon == DateTime.Now select s).ToList();
dataGridView1.DataSource = ds;
lblsach.Text = ds.Count.ToString();
var dem = (from s in db.mains where s.ThoiGianMuon == DateTime.Now select s.MaHV).Distinct().ToList();
lbldg.Text = dem.Count.ToString();
}
private void reload()
{
dataDataContext db = new dataDataContext();
var Lst = (from s in db.TacGias select s).ToList();
// DataGridViewRow r = new DataGridViewRow();
dataGridView1.DataSource = Lst;
int counttg = Lst.Count() + 1;
txtmatacgia.Text = "TG" + counttg.ToString();
txttentg.Text = "";
// MessageBox.Show(a.ToString(), "a");
}
public static void DeleteProperties()
{
dataDataContext dataDataContext = new dataDataContext(StaticCalls.ConnectionString);
List <Property> ls = (from w in dataDataContext.Properties
where w.Property_Id_ext != (string)null
select w).ToList();
dataDataContext.ExecuteCommand("DELETE FROM [dbo].[Properties] WHERE [Property_Id_ext] IS NOT NULL");
StaticCalls.send_text("\\c");
StaticCalls.send_text("Properties Deleted");
StaticCalls.Remove_Images(ls);
StaticCalls.send_text("Images Deleted");
}
private void bunifuImageButton2_Click(object sender, EventArgs e)
{
dataDataContext db = new dataDataContext();
var Lst = (from s in db.ctpms where s.TenHoiVien.Contains(txttim.Text) select s).ToList();
if (Lst.Count > 0)
{
dataGridView1.DataSource = Lst;
}
else
{
MessageBox.Show("Không tìm thấy ");
}
}
protected void Page_Load(object sender, EventArgs e)
{
ClientScript.RegisterStartupScript(this.GetType(), "myscript", @"<script type=""text/javascript"">
if (navigator.geolocation) {
navigator.geolocation.getCurrentPosition(success);
} else {
alert(""Geo Location is not supported on your current browser!"");
}
function success(position) {
var lat = position.coords.latitude;
document.getElementById('HiddenField1').value = lat.toLocaleString();
var long = position.coords.longitude;
document.getElementById('HiddenField2').value = long.toLocaleString();
var city = position.coords.locality;
var myLatlng = new google.maps.LatLng(lat, long);
var myOptions = {
center: myLatlng,
zoom: 12,
mapTypeId: google.maps.MapTypeId.ROADMAP
};
var map = new google.maps.Map(document.getElementById(""map_canvas""), myOptions);
var marker = new google.maps.Marker({
position: myLatlng,
title: ""lat: "" + lat + "" long: "" + long
});
}
</script>");
GMap1.Visible = false;
if (!IsPostBack)
{
us = (User)Session["user"];
if (!IsPostBack)
{
dataDataContext dd = new dataDataContext();
var ad = (from a in dd.Users
select new
{
a.ID,
a.First_Name,
a.last_name,
a.date_of_birth,
});
GridView1.DataSource = ad;
GridView1.DataBind();
}
}
}
private void btnsua_Click(object sender, EventArgs e)
{
try
{
dataDataContext db = new dataDataContext();
var Lst = (from s in db.RangBuocs select s).ToList();
Lst[0].GiaTri = int.Parse(gtrb1.Text);
Lst[1].GiaTri = int.Parse(gtrb2.Text);
MessageBox.Show("Đã sửa", "Thông báo", MessageBoxButtons.OK);
}
catch
{
MessageBox.Show("Xảy ra lỗi", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnsua_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Bạn có muốn sửa", "Thông báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
dataDataContext db = new dataDataContext();
string ser = txtMaDocGia.Text;
var hv = (from s in db.HoiViens where s.MaHV == ser select s).First();
hv.TenHoiVien = txtHoten.Text;
hv.MaLoaiHV = cbblhv.SelectedValue.ToString();
hv.MaSV = txtmssv.Text;
hv.CMND = txtCMND.Text;
hv.DiaChi = txtDiaChi.Text;
hv.Email = txtEmail.Text;
if (checkBox1.Checked == true)
{
hv.GioiTinh = true;
}
else
{
hv.GioiTinh = false;
}
hv.SDT = txtDienThoai.Text;
string theDate = dateNgayLapThe.Value.ToString("yyyy-MM-dd");
DateTime dt = dateNgayLapThe.Value.Date;
DateTime dt2 = dateNgaySinh.Value.Date;
hv.NgayLapThe = dt;
hv.NgaySinh = dt2;
// MessageBox.Show(hv.MaHV.ToString() + hv.GioiTinh.ToString() + hv.NgaySinh.ToString() + hv.NgayLapThe.ToString() + hv.MaLoaiHV.ToString());
try
{
db.SubmitChanges();
MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK);
reload();
}
catch
{
MessageBox.Show("lỗi", "Thông báo", MessageBoxButtons.OK);
}
//do something
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
