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; } }