public int updateHeThong(HeThongDTO htDTO)
{
try
{
var querry = (from ht in htDataContext.hethongs
where ht.manhanvien == htDTO.Manhanvien
select ht).FirstOrDefault <hethong>();
//querry.username = htDTO.Username;
querry.password = htDTO.Password;
htDataContext.SubmitChanges();
return(1);
}
catch
{
return(0);
}
/* try
* {
* htDataContext.Connection.Open();
* System.Data.Common.DbTransaction transaction = htDataContext.Connection.BeginTransaction();
* htDataContext.Transaction = transaction;
*
* deleteHeThong(htDTO.Manhanvien);
* insertHeThong(htDTO);
*
* htDataContext.Transaction.Commit();
* return 1;
* }
* catch(Exception)
* {
* htDataContext.Transaction.Rollback();
* return 0;
* }*/
}
public int insertHeThong(HeThongDTO htDTO)
{
try
{
hethong ht = new hethong();
ht.username = htDTO.Username;
ht.manhanvien = htDTO.Manhanvien;
ht.password = htDTO.Password;
htDataContext.hethongs.InsertOnSubmit(ht);
htDataContext.SubmitChanges();
return(1);
}
catch
{
return(0);
}
}
public int updateHeThong(HeThongDTO htDTO)
{
try
{
var querry = (from ht in htDataContext.hethongs
where ht.manhanvien == htDTO.Manhanvien
select ht).FirstOrDefault<hethong>();
//querry.username = htDTO.Username;
querry.password = htDTO.Password;
htDataContext.SubmitChanges();
return 1;
}
catch
{
return 0;
}
/* try
{
htDataContext.Connection.Open();
System.Data.Common.DbTransaction transaction = htDataContext.Connection.BeginTransaction();
htDataContext.Transaction = transaction;
deleteHeThong(htDTO.Manhanvien);
insertHeThong(htDTO);
htDataContext.Transaction.Commit();
return 1;
}
catch(Exception)
{
htDataContext.Transaction.Rollback();
return 0;
}*/
}
public int insertHeThong(HeThongDTO htDTO)
{
try
{
hethong ht = new hethong();
ht.username = htDTO.Username;
ht.manhanvien = htDTO.Manhanvien;
ht.password = htDTO.Password;
htDataContext.hethongs.InsertOnSubmit(ht);
htDataContext.SubmitChanges();
return 1;
}
catch
{
return 0;
}
}
