public void Update(string id, DiemSV diemSV)
{
diemsvCollection.UpdateOne(
Builders <DiemSV> .Filter.Eq("_id", new ObjectId(id)),
Builders <DiemSV> .Update.Set("masv", diemSV.MaSV)
.Set("diemky1", diemSV.DiemKy1)
.Set("diemky2", diemSV.DiemKy2)
);
}
public List <DiemSV> GetListDiemSV()
{
List <DiemSV> list = new List <DiemSV>();
DataTable data = DataProvider.Instance.ExecuteQuery("USP_GetDiemSVList");
foreach (DataRow item in data.Rows)
{
DiemSV diemsv = new DiemSV(item);
list.Add(diemsv);
}
return(list);
}
public List <DiemSV> SearchDiemSVByMaLopHP(string malophp)
{
List <DiemSV> list = new List <DiemSV>();
string query = string.Format("select * from BANGDIEMCT where [dbo].[GetUnsignString](MALOPHP) " +
"like N'%'+[dbo].[GetUnsignString](N'{0}')+'%' ", malophp);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
DiemSV diemsv = new DiemSV(item);
list.Add(diemsv);
}
return(list);
}
public ActionResult Edit(string Id, DiemSV diemSV)
{
try
{
var dao = new DiemSV_DAO();
dao.Update(Id, diemSV);
return(RedirectToAction("Index"));
}
catch
{
ModelState.AddModelError("", "Error in saving data");
return(View(diemSV));
}
}
public ActionResult Create(DiemSV diemSV)
{
var dao = new DiemSV_DAO();
if (ModelState.IsValid)
{
dao.Create(diemSV);
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Error in saving data");
return(View(diemSV));
}
}
protected void ExportToExcel(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=BangDiem.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
Response.ContentEncoding = System.Text.Encoding.UTF8;
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
hw.WriteLine("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">");
DiemSV.RenderControl(hw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
void Load_data()
{
if (Convert.ToInt32(Request.QueryString["MaSv"]) > 0)
{
int Masv = (Convert.ToInt32(Request.QueryString["Masv"]));
using (var conn = SQL.GetConnection())
{
//conn.Open();
SqlCommand sqlCmd = new SqlCommand("select MonHoc.*,Diem.*,HoTen from Diem,MonHoc,SinhVien where Diem.MaMon=MonHoc.MaMon and Diem.MaSv=SinhVien.MaSv and SinhVien.MaSv='" + Masv + "'", conn);
DataSet dt = new DataSet();
SqlDataAdapter sqlAdap = new SqlDataAdapter(sqlCmd);
sqlAdap.Fill(dt);
DiemSV.DataSource = dt;
DiemSV.DataBind();
conn.Close();
}
}
}
public void InsertData()
{
int masv = 1;
string path = @"C:\Users\Hieu Bui\source\repos\QuanLySinhVien\QuanLySinhVien\Data\data.txt";
string[] lines = File.ReadAllLines(path);
for (int i = 0; i < lines.Length; i++)
{
string line = lines[i];
string[] words = line.Split(',');
var diemSV = new DiemSV()
{
MaSV = masv.ToString(),
DiemKy1 = float.Parse(words[0]),
DiemKy2 = float.Parse(words[1]),
KetQua = Convert.ToBoolean(Convert.ToInt32(words[2]))
};
masv++;
diemsvCollection.InsertOne(diemSV);
}
}
public void Create(DiemSV diemSV)
{
diemsvCollection.InsertOne(diemSV);
}
