public bool Add(BusDTO dto)
{
string query = "Insert into Bus values(@id,@bsx,@brand,@DateRegistration,@ownerId,@idTuyenDuong)";
SqlParameter[] sqlParameters = new SqlParameter[6];
sqlParameters[0] = new SqlParameter("@id", SqlDbType.NVarChar)
{
Value = dto.Id
};
sqlParameters[1] = new SqlParameter("@bsx", SqlDbType.NVarChar)
{
Value = dto.BSX
};
sqlParameters[2] = new SqlParameter("@brand", SqlDbType.NVarChar)
{
Value = dto.Brand
};
sqlParameters[3] = new SqlParameter("@DateRegistration", SqlDbType.Date)
{
Value = dto.DateRegistration
};
sqlParameters[4] = new SqlParameter("@ownerId", SqlDbType.NVarChar)
{
Value = dto.OwnerID
};
sqlParameters[5] = new SqlParameter("@idTuyenDuong", SqlDbType.Int)
{
Value = dto.RouteID
};
try
{
conn.ExecuteInsertQuery(query, sqlParameters);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Add(StaffDTO dto)
{
bool check = true;
string sql = "insert into Staff values (@MSNV,@CMND,@Name,@DateOfBirth,@Phone,@Role,@password) ";
try
{
SqlParameter[] sqlParameters = new SqlParameter[7];
sqlParameters[0] = new SqlParameter("@MSNV", SqlDbType.NVarChar)
{
Value = dto.MSNV
};
sqlParameters[1] = new SqlParameter("@CMND", SqlDbType.NVarChar)
{
Value = dto.CMND
};
sqlParameters[2] = new SqlParameter("@Name", SqlDbType.NVarChar)
{
Value = dto.Name
};
sqlParameters[3] = new SqlParameter("@DateOfBirth", SqlDbType.NVarChar)
{
Value = dto.Date
};
sqlParameters[4] = new SqlParameter("@Phone", SqlDbType.NVarChar)
{
Value = dto.Phone
};
sqlParameters[5] = new SqlParameter("@Role", SqlDbType.NVarChar)
{
Value = dto.RoleID
};
sqlParameters[6] = new SqlParameter("@password", SqlDbType.NVarChar)
{
Value = dto.Password
};
check = conn.ExecuteInsertQuery(sql, sqlParameters);
}
catch (Exception)
{
return(false);
throw;
}
return(check);
}
public bool Add(RouteDTO dto)
{
string query = "Insert into Route(TuyenDuong) values(@name)";
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@name", SqlDbType.NVarChar)
{
Value = dto.TuyenDuong
};
try
{
conn.ExecuteInsertQuery(query, sqlParameters);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Add(BusStationDTO dto)
{
string query = "Insert into BusStation values(@BusID,@MSNVDRIVER,@DepartureTime,@TimeBack,@MSNVCAST,@Status)";
SqlParameter[] sqlParameters = new SqlParameter[6];
sqlParameters[0] = new SqlParameter("@BusID", SqlDbType.NVarChar)
{
Value = dto.BusID
};
sqlParameters[1] = new SqlParameter("@MSNVDRIVER", SqlDbType.NVarChar)
{
Value = dto.MSNVDRIVER
};
sqlParameters[2] = new SqlParameter("@TimeBack", SqlDbType.DateTime)
{
Value = dto.TimeBack
};
sqlParameters[3] = new SqlParameter("@MSNVCAST", SqlDbType.NVarChar)
{
Value = dto.MSNVCAST
};
sqlParameters[4] = new SqlParameter("@Status", SqlDbType.Int)
{
Value = dto.Status
};
sqlParameters[5] = new SqlParameter("@DepartureTime", SqlDbType.DateTime)
{
Value = dto.DepartureTime
};
try
{
conn.ExecuteInsertQuery(query, sqlParameters);
return(true);
}
catch (Exception ex)
{
return(false);
throw ex;
}
}
public bool Add(OwnerDTO dto)
{
string query = "Insert into Owner values(@id,@name,@phone,@DoB,@CMND,@address)";
SqlParameter[] sqlParameters = new SqlParameter[6];
sqlParameters[0] = new SqlParameter("@id", SqlDbType.NVarChar)
{
Value = dto.Id
};
sqlParameters[1] = new SqlParameter("@name", SqlDbType.NVarChar)
{
Value = dto.Name
};
sqlParameters[2] = new SqlParameter("@phone", SqlDbType.NVarChar)
{
Value = dto.Phone
};
sqlParameters[3] = new SqlParameter("@DoB", SqlDbType.Date)
{
Value = dto.DateOfBirth
};
sqlParameters[4] = new SqlParameter("@CMND", SqlDbType.NVarChar)
{
Value = dto.CMND
};
sqlParameters[5] = new SqlParameter("@address", SqlDbType.NVarChar)
{
Value = dto.Address
};
try
{
conn.ExecuteInsertQuery(query, sqlParameters);
return(true);
}
catch (Exception ex)
{
Trace.TraceError(ex.Message);
throw ex;
}
}
