public bool Add(DTO_CaTruc dto) { try { string sql = string.Format("INSERT INTO [dbo].[CATRUC]([MACA],[THOIGIANTRUC])" + "VALUES('{0}', '{1}')", dto.MACA1, dto.THOIGIANTRUC1); db.ExecuteNonQuery(sql); return(true); }catch (Exception ex) { return(false); } }
public bool Add(DTO_DSYTA dto) { try { string sql = string.Format("INSERT[dbo].[DS_YTA]([MASOYTA], [HOTEN], [SDT], [DIACHI]) " + "VALUES(N'{0}', N'{1}', '{2}', N'{3}')", dto.MASOYTA1, dto.HOTEN1, dto.SDT1, dto.DIACHI1); db.ExecuteNonQuery(sql); return(true); } catch (Exception ex) { return(false); } }
public bool Add(DTO_BenhNhan dto) { try { string sql = string.Format("INSERT INTO [dbo].[BENH_NHAN]([MASOBN],[HOTEN],[DIACHI],[MAPHONG]) VALUES('{0}',N'{1}',N'{2}','{3}')" , dto.MASOBN1, dto.HOTEN1, dto.DIACHI1, dto.MAPHONG1); db.ExecuteNonQuery(sql); return(true); } catch (Exception ex) { return(false); } }
public bool Add(DTO_YTaTruc dto) { try { string sql = string.Format("INSERT INTO [dbo].[YTA_TRUC]([MASOYTA],[MACA],[NGAY],[MAPHONG])" + "VALUES('{0}', '{1}', '{2}', '{3}')", dto.MASOYTA1, dto.MACA1, dto.NGAY1, dto.MAPHONG1); db.ExecuteNonQuery(sql); return(true); } catch (Exception ex) { return(false); } }
public bool Add(DTO_Account dto) { try { string sql = string.Format("INSERT INTO [dbo].[ACCOUNT]([USERNAME],[PASS],[TYPE],[DISPLAYNAME])" + " VALUES(N'{0}',N'1962026656160185351301320480154111117132155',{1},N'{2}')", dto.User, dto.Type, dto.Display); db.ExecuteNonQuery(sql); return(true); } catch (Exception) { return(false); } }
public bool Add(DTO_PhongBenh dto) { try { string sql = string.Format("INSERT INTO[dbo].[PHONGBENH]([MAPHONG],[VITRI])" + "VALUES('{0}', N'{1}')", dto.MAPHONG1, dto.VITRI1); db.ExecuteNonQuery(sql); return(true); } catch (Exception ex) { return(false); } }