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